Oracle
1Z0-054 · Question #155
On examining the Automatic Workload Repository (AWR) report, you find that log file sync appears among the top 5 wait events.On further investigation, you notice that the average time waited for…
The correct answer is D. The application might be committing frequently. See the full explanation below for the reasoning.
Question
On examining the Automatic Workload Repository (AWR) report, you find that log file sync appears among the top 5 wait events.On further investigation, you notice that the average time waited for this event is low, but the number of waits are high. What does this imply?
Options
- ADBWR is slow.
- BLGWR is slow due to slow I/O.
- CRedo log buffer size is insufficient.
- DThe application might be committing frequently.
How the community answered
(40 responses)- A3% (1)
- B5% (2)
- C13% (5)
- D80% (32)
Community Discussion
No community discussion yet for this question.