Examine the output of the following query:
SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps,
2 a.immediate_gets,a.immediate_misses,b.pid
3 FROM v$latch a, v$latchholder b, v$latchname c
4 WHERE a.addr = b.laddr(+) and a.latch# = c.latch#
5 AND c.name LIKE ‘&latch_name%’ ORDER BY a.latch#;
LATCH NAME ADDR GETS MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES
———— ——– ——– ——- —— ————– —————-
shared pool 20016544 8520540 14112 3137 0 0
Which two conclusions can you draw from this? (Choose two.)
A.
The latch was requested in no wait mode.
B.
The latch was requested in willing-to-wait mode.
C.
The shared pool operations to allocate and free memory in it caused the misses.
D.
Automatic Memory Management is not enabled because the IMMEDIATE_GETS and
IMMEDIATE_MISSES columns have zero in them.
A is wrong. immediate_gets is 0
B is right. gets are willing-to-wait mode
C is right.
D is wrong. nothing to do with AMM
So B.C. are correct