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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

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

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply