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


Please Help Members By Posting Answers For Below Questions

What are the operating modes in which database mirroring runs? : sql server DBA

876


What are the commands you'd issue to show the explain plan for "select * from dual"?

2001


how can you process messages in order asynchronously?

766


what do you understand by flashback feature of oracle?

795


What is the difference between the 2 operating modes of database mirroring? : sql server DBA

760


What is the difference between clustered and non-clustered index? : sql server DBA

790


What are the different types of database compression introduced in sql server 2008? : sql server DBA

829


When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

794


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3511


Can you redefine a table online?

891


What purpose does the model database server? : sql server DBA

845


Where would you look for errors from the database engine?

2615


How would you go about verifying the network name that the local_listener is currently using?

2985


how can you get actual data change values from previous transactions in oracle?

832


can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

1540