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

1 Answers
3566 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How to start your 10g xe server?

1018

Can group functions be mixed with non-group selection fields?

1008

How to create lov dynamically at runtime & attach to text field?

1137

How do I connect to oracle?

1015

Explain view?

1013

What is ordinary table in oracle?

1132

Explain what are the type of synonyms?

1094

What is an external table?

999

Explain the use of record option in exp command.

987

How to revoke create session privilege from a user in oracle?

998

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2249

How to delete a column in an existing table in oracle?

1050

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....

2046

Explain mutating triggers.

1010

What is set verify off in oracle?

1075