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

How to fetch the row which has the max value for a column?

What is raw datatype in oracle?

How to store pictures on to the database?

What is E-R diagram ?

How to insert a new row into a table in oracle?

When a form is invoked with call_form, Does oracle forms issues a save point ?

How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?

Who i will insert 1 lacks record in a Database table

Can we commit inside a function in oracle?

how to clone 9i Database on to 10g Database.

What is the diff between Oracle and SQL Server

How do I manually create a database in oracle?

For more Oracle General Interview Questions Click Here