1Z0-054 · Question #55
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…
The correct answer is A. reducing hard parses B. increasing the size of the shared pool. See the full explanation below for the reasoning.
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
How the community answered
(31 responses)- A74% (23)
- C6% (2)
- D3% (1)
- E16% (5)
Community Discussion
No community discussion yet for this question.