What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
Answer Posted / 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 |
Post New Answer View All Answers
How to start your 10g xe server?
Can group functions be mixed with non-group selection fields?
How to create lov dynamically at runtime & attach to text field?
How do I connect to oracle?
Explain view?
What is ordinary table in oracle?
Explain what are the type of synonyms?
What is an external table?
Explain the use of record option in exp command.
How to revoke create session privilege from a user in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to delete a column in an existing table in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Explain mutating triggers.
What is set verify off in oracle?