How would you determine what sessions are connected and what
resources they are waiting for?
- 2 Answers
- 8004 Views
- I also Faced
- E-Mail Answers
Answer Posted / santo
Query v$sesstat or v$waitstat views.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
Why would you call update statistics? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is ora 24313?what is the procedure to exclude that error?
internal architecture
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?
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 logical system in sap basis
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?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
