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
- 6550 Views
- I also Faced
- E-Mail Answers
Answer Posted / kishore
select count(*),username from v$session where group by username;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the default fill factor value? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is ora 24313?what is the procedure to exclude that error?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can a session indicate its interest in receiving alerts?
how can you process messages in order asynchronously?
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 would you look for errors from the database engine?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
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
