What SQL query from v$session can you run to show how many sessions are logged

What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?

Question Posted / venkateswararao

What SQL query from v$session can you run to show how many sessions are logged in as a particular u..

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

More Oracle General Interview Questions

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

Can multiple columns be used in group by in oracle?

How can I combine multiple rows into a comma-delimited list in oracle?

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

What is the difference between a vector and an Array? (Java)

What is the difference between a hot backup and a cold backup in oracle?

what is the syntax of SELECT command?

What are Clusters ?

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

What is an anonymous block?

Why does Oracle not permit the use of PCTUSED with indexes?

What privilege is needed for a user to create views in oracle?

For more Oracle General Interview Questions Click Here