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

Question

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

Accepted Answer

A. About 24% of the parse calls were able to find a cursor to share. C. Library cache misses happened 118 times because invalidations occurred due to DDL on the

Answer

B. DML locks were requested 65,900 times for objects in the SQL AREA.

Answer

D. Reparsing of SQL statements before they had finished executing happened 28 times due to

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…

Question

Options

How the community answered

Community Discussion