SQL> select count(SID),USERNAME from v$session group by USERNAME;

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

Question Posted / saraswathi muthuraman

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

Please Help Members By Posting Answers For Below Questions

Explain how you would restore a database using RMAN to Point in Time?

2184

What is a tns file?

1040

Can we store pictures in the database and if so, how it can be done?

1089

How to update a table row with a record?

1063

what is the difference between restoring and recovering?

1052

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1162

How to rename a tablespace in oracle?

1123

How do I learn what codesets are available in oracle?

1076

How do we get field detail of a table?

1125

What is the difference between formal parameters and actual parameters?

1152

What is dual table oracle?

1027

Is rowid unique in oracle?

1042

How to estimate disk space needed for an export job?

1103

Explain user account with reference to oracle.

1028

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1123