What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
- 1 Answers
- 3202 Views
- I also Faced
- E-Mail Answers
Answer / saraswathi muthuraman
SQL> select count(SID),USERNAME from v$session group by
USERNAME;
14
14 raghavan
2 P_21533
1 Saras
4 rows selected.
SQL>
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the data types in oracle?
Explain the features of oracle?
What is the difference between primary key and unique key and foreign key in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to do clean up if create database failed?
What is columnar storage what is the advantage?
Does facebook use oracle?
What's dateware house and what's clustor with practicle example
how to use sequence and what use of sequence cache
Explain user account with reference to oracle.
What is self-referential integrity constraint ?
What is a Shared SQL pool ?
Oracle General 
