Which two observations are correct?

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.)

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.



Leave a Reply 1

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


L. Zhu

L. Zhu

A is right. GETHITRATIO is .237 = 24%
B is wrong. nothing to do with DML lock
C is right. 118 invalidation due to DDL
D is wrong. 28 reloads not due to modification