Oracle
1Z0-074 · Question #3
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.)
See the full explanation below for the reasoning.
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.
Community Discussion
No community discussion yet for this question.