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.