What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
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 |
What are triggers in oracle?
which sql command we can use to get a print out from oracle?
what is load balancing and what u have used to do this?(sql loader)
Explain the concept of the DUAL table.
What are nested tables?
How to lock and unlock a user account in oracle?
what is the syntax of update command?
What is autonomous transaction?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Explain the use of online redo log files in oracle.
What is set verify off in oracle?
Differentiate between translate and replace?