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

What is pragma autonomous transaction in oracle?

1070

Give the various rollback segment states.

1052

Is oracle a programming language?

990

How do you bind variables in oracle?

981

What is a tns service name?

1009

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

What are the different types of synonyms?

1140

What's dateware house and what's clustor with practicle example

2175

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

2340

Explain oracle insert into command?

1115

How to write a left outer join with the where clause in oracle?

1085

How do you tell what your machine name is and what is its IP address?

2097

How do I find my oracle client driver version?

1040

What are the arithmetic operations?

1084

State the various uses of dbcc command?

1060