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.pid3 FROM v$latch a, v$latchholder b, v$latchname c4 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 0Which 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.
Examine the output of the following query:SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps,2 a.immediate_gets,a.immedi
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am