What SQL query from v$session can you run to show how many
sessions are logged in as a particular user account?
Answer Posted / diksha
select count(*) from v$session where username like ''
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is replication? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What is a correlated sub-query? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is fill factor? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How to start SQL Server in minimal configuration mode?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the recovery models for a database? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you communicate with operating system files from oracle?