What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 3 Answers
- 5580 Views
- I also Faced
- E-Mail Answers
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 do you understand by fine-grained auditing?
How would you extract DDL of a table without using a GUI tool?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can you get actual data change values from previous transactions in oracle?
how can you connect from 10g user to 11g user??
What is a correlated sub-query? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how does an oracle clusterware manage crs resources?
Query processing is slow(eg select query)how will u solve that
Explain materialized views and how they are used.
how can you record information about current session?
