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

How to define default values for formal parameters?

985

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2147

What is the order of defining local variables and sub procedures/functions?

1006

How to delete a column in an existing table?

1020

What are a collation and state the different types of collation sensitivity?

1095

How to create a testing table in oracle?

948

What are the attributes that are found in a cursor?

1013

What is Java Pool in Oracle?

1094

How do I call oracle stored procedures that take no parameters?

1025

What are temporal data types in oracle?

1066

20. Using a set operator, display the client number of all clients who have never placed an order.

2147

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2068

In which language oracle has been developed?

1017

Explain about achiever in sql?

981

Explain the difference between replace() and translate() functions in oracle?

976