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 |
Can we convert a date to char in oracle and if so, what would be the syntax?
What is a Shared SQL pool ?
How to define a specific record type?
How to use select statement to count the number of rows in oracle?
How do I recompile a procedure in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to store pictures on to the database?
What is the difference between "as" and "is" in an oracle stored procedure?
Difference between NO DATA FOUND and %NOTFOUND?
How to display row numbers with the records?
What is object data modeling?
what is shell?