Free sharing of new updated Oracle 1Z0-054 exam practice test. If you are looking to get certified in short possible time, better try Flydumps latest new version Oracle 1Z0-054 with all new questions and answers added,visit Flydumps.com to free Oracle 1Z0-054 download vce and pdf files.
QUESTION 52
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.