Examine the following query and its output:
SQL>SELECT namespace, gets, gethits, gethitratio, pins, pinhits, reloads,invalidations
FROM v$librarycache
WHERE namespace = ‘SQL AREA’;
NAMESPACE GETS GETHITS GETHITRATIO PINS PINHITS RELOADS INVALIDATIONS
——— —– ——- ———– —– ——- ——– ————-
SQL AREA 11942 2832 .237146207 65900 62486 28 118
Which two observations are correct? (Choose two.)
A.
About 24% of the parse calls were able to find a cursor to share.
B.
DML locks were requested 65,900 times for objects in the SQL AREA.
C.
Library cache misses happened 118 times because invalidations occurred due to DDL on the dependant objects.
D.
Reparsing of SQL statements before they had finished executing happened 28 times due to modification of a dependent object.