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

Question

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

Accepted Answer

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.

Answer

A. The latch was requested in no wait mode.

Answer

D. Automatic Memory Management is not enabled because the IMMEDIATE_GETS and

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…

Question

Options

How the community answered

Community Discussion