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 operating modes in which database mirroring runs? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can you process messages in order asynchronously?
what do you understand by flashback feature of oracle?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Can you redefine a table online?
What purpose does the model database server? : sql server DBA
Where would you look for errors from the database engine?
How would you go about verifying the network name that the local_listener is currently using?
how can you get actual data change values from previous transactions in oracle?
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