1Z0-054 · Question #57
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)…
The correct answer is C. The GETS column shows the number of times a mutex/location was requested by the requesting. See the full explanation below for the reasoning.
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
How the community answered
(21 responses)- A10% (2)
- B5% (1)
- C71% (15)
- D14% (3)
Community Discussion
No community discussion yet for this question.