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

Answer Posted / kishore

select count(*),username from v$session where group by username;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2343


What are the different types of database compression introduced in sql server 2008? : sql server DBA

849


Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2342


how can you process messages in order asynchronously?

785


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1776


What is a system database and what is a user database? : sql server DBA

868


What is dcl? : sql server DBA

937


What are the recovery models for a database? : sql server DBA

861


A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2250


What is a correlated sub-query? : sql server DBA

817


What is dbcc? : sql server DBA

1022


how can you communicate with operating system files from oracle?

828


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2099


What are the different sql server versions you have worked on? : sql server DBA

812


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

945