What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
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 |
How to resolve name conflicts between variables and columns?
how to delete all duplicate records from a table using subquery?
What are the set operators union, union all, minus & intersect meant to do?
What is the dynamic sql in oracle?
What's dateware house and what's clustor with practicle example
Describe the types of sub query?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
IS it possible to built the oracle database without setting the kernal parameters?
How do I limit the number of oracle database connections generated by weblogic server?
Does oracle database need java?
How to filter out duplications in the returning rows using oracle?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?