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

How do we display rows from the table without duplicates?

Explain index?

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

Why does Oracle not permit the use of PCTUSED with indexes?

can you write commit in triggers?

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

How can you use check constraints for self referential integrity?

What is the parameter mode that can be passed to a procedure?

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

What is an oracle cursor variable?

does Oracle has only one table space?

Explain user account with reference to oracle.

For more Oracle General Interview Questions Click Here