Which statement is true?

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?

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?

A.
Each row in the output represents a SQL statement that had to wait for mutexes.

B.
The Cursor Stat and Cursor Pin SLEEPS indicate that the CURSOR_SHARING parameter is
set to EXACT.

C.
The GETS column shows the number of times a mutex/location was requested by the
requesting session while being held by the blocking session.

D.
The sum of numbers in the GETS and SLEEPS columns indicates the number of times a
mutex/location was requested by the requesting session while being held by the blocking session.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

C is what oracle doc says

So C is correct