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 a data segment?

647

How to install oracle database 10g xe?

560

Is primary key indexed by default in oracle?

543

Explain the difference between sql and oracle?

578

What is a nvl function? How can it be used?

559

What is the implicit cursor in oracle?

566

How to define a data field as not null?

631

How to create a new table in oracle?

589

Explain view?

577

Explain what does a control file contain?

607

Where do you use decode and case statements?

551

How to best split csv strings in oracle 9i?

584

How to invoke the original export import utilities?

505

How to update values on multiple rows in oracle?

596

What is primefaces used for?

559