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
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
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.
how can you process messages in order asynchronously?
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.
What is a system database and what is a user database? : sql server DBA
What is dcl? : sql server DBA
What are the recovery models for a database? : sql server DBA
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?
What is a correlated sub-query? : sql server DBA
What is dbcc? : sql server DBA
how can you communicate with operating system files from oracle?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What are the different sql server versions you have worked on? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA