Oracle
1Z0-074 · Question #3
1Z0-074 Question #3: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #3. The question stem and answer options stay visible for context.
Question
You notice a large number of latch: cache buffers lru chain and latch: cache buffers chains wait events. Which four might be reasons for these? (Choose four.)
Options
- AThe same small number of blocks are repeatedly accessed by different sessions simultaneously.
- BThe buffer cache is undersized.
- CCursors are closed explicitly after each execution.
- DA large number of connected user sessions are idle.
- EDBWR is not writing the dirty buffers fast enough.
- FBlocks are ageing out of the buffer cache frequently.
- GToo many sort operations are being performed.
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 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.