How would you determine what sessions are connected and what
resources they are waiting for?
Answer Posted / santo
Query v$sesstat or v$waitstat views.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How do you open a cluster administrator? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is logical system in sap basis
What is transparent data encryption? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what are the performance views in an oracle rac environment?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is the default port no on which sql server listens? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
who owns the operating system files created by the utl_file package?
How would you extract DDL of a table without using a GUI tool?
What are the recovery models for a database? : sql server DBA