Interested to Buy Any Domain ? << Click Here >> for more details...
What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 3 Answers
- 6408 Views
- I also Faced
- E-Mail Answers
Answer Posted / diksha
select count(*) from v$session where username like ''
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can you record information about current session?
How would you go about verifying the network name that the local_listener is currently using?
how can you process messages in order asynchronously?
what is a user-defined lock?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what do you understand by fine-grained auditing?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
what is the use of recording information about current session?
how can you get actual data change values from previous transactions in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you enable flashback feature?
