What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
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
when does an alert gets signaled?
What are the commands used in dcl? : sql server DBA
What is a correlated sub-query? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is the use of ocr?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What is the default fill factor value? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different ways you can create databases in sql server? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is ora 24313?what is the procedure to exclude that error?