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
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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 is the use of recording information about current session?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is the diffrence between core dba and apps dba?
How do you open a cluster administrator? : sql server DBA
What happens on checkpoint? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is ora 24313?what is the procedure to exclude that error?
Why would you use sql agent? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?