Oracle
1Z0-054 · Question #55
1Z0-054 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
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 You calculated the Gets-to-Misses ratio, which is .99834, and this ratio is dropping over a period of time. Which two actions can improve this? (Choose two.)
Options
- Areducing hard parses
- Bincreasing the size of the shared pool
- Cusing only dedicated server connections
- Dsetting the CURSOR_SHARING parameter to EXACT
- Eencouraging the use of more literal SQL statements
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.