What SQL query from v$session can you run to show how many sessions are logged

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

Question Posted / venkateswararao

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

Answer / 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

More Oracle General Interview Questions

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

what is query and types of query

Can we create index on views?

What happens if you set the sga too low in oracle?

How do I recompile a procedure in oracle?

In what script is snap$ created? In what script is the scott/tiger schema created?

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

Can the query output be sorted by multiple columns in oracle?

When does a Transaction end ?

How to view the tablespaces in the current database?

What is RULE-based approach to optimization ?

How to create a table in a specific tablespace?

For more Oracle General Interview Questions Click Here