Oracle
1Z0-054 · Question #85
You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events: Event Total Seconds Total Average Wait Name Waits Waiting Timeouts (in secs)…
The correct answer is D. The work areas are too large to fit in memory and are, therefore, written to disk. See the full explanation below for the reasoning.
Question
You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events:
Event Total Seconds Total Average Wait Name Waits Waiting Timeouts (in secs) ------------------------------ ------------ -------- ------------ ----- ---- direct path read temp 18,274 11,312 16,282 .619 direct path write temp 3,251 416 25 .127 What do these wait events indicate?
Options
- AThe DBWn processes are not creating free buffers fast enough.
- BThe buffer cache is too small and block replacement is excessive.
- CThe aggressive checkpointing policy is causing too many writes to disk.
- DThe work areas are too large to fit in memory and are, therefore, written to disk.
How the community answered
(33 responses)- A12% (4)
- B6% (2)
- C6% (2)
- D76% (25)
Community Discussion
No community discussion yet for this question.