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 is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you create a user-defined lock?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How would you best determine why your MVIEW couldn't FAST REFRESH?
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
how to restore files with rman?
what is the role of dip user in our database?
What are the commands used in dcl? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What happens on checkpoint? : sql server DBA
how can you process messages in order asynchronously?
how can you initialize log miner?
what is the diffrence between core dba and apps dba?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA