What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
Answer Posted / braj123
select count(*) from v$session where user_name="**";
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
when does an alert gets signaled?
What authentication modes does sql server support? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what are the types of connection load-balancing?
What are the different sql server versions you have worked on? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : 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?
how can you create a user-defined lock?
how can you get actual data change values from previous transactions in oracle?
What is the difference between clustered and non-clustered index? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is replication? : sql server DBA
What happens on checkpoint? : sql server DBA