Oracle
1Z0-054 · Question #57
1Z0-054 Question #57: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #57. The question stem and answer options stay visible for context.
Question
Examine the output of the query given below: SQL> SELECT mutex_type, location, sum(gets), sum(sleeps) FROM v$mutex_sleep_history GROUP BY mutex_type, location; MUTEX_TYPE LOCATION SUM(GETS) SUM(SLEEPS) -------------- ------------------------------------- ---------- Library Cache kglhdgn1 62 8669586 4538 Library Cache kglget2 2 2016618 24 Cursor Stat kkocsStoreBindAwareStats [KKSSTALOC8] 2975 1 Cursor Pin kkslce [KKSCHLPIN2] 666831 678 Library Cache kgllkdl1 85 3369224 110 Library Cache kglpnal1 90 224199 13 Library Cache kglic1 49 42068 10 Library Cache kglpin1 4 9620087 374 Library Cache kglpndl1 95 2065089 79 9 rows selected. Which statement is true?
Options
- AEach row in the output represents a SQL statement that had to wait for mutexes.
- BThe Cursor Stat and Cursor Pin SLEEPS indicate that the CURSOR_SHARING parameter is set
- CThe GETS column shows the number of times a mutex/location was requested by the requesting
- DThe sum of numbers in the GETS and SLEEPS columns indicates the number of times a
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.