Oracle
1Z0-054 · Question #156
During a proactive database performance monitoring routine, on examining the AWR report you find that log file sync appears among the top 5 wait events. What does this event indicate?
The correct answer is C. Frequent commits or rollbacks are taking place in the application. See the full explanation below for the reasoning.
Question
During a proactive database performance monitoring routine, on examining the AWR report you find that log file sync appears among the top 5 wait events. What does this event indicate?
Options
- AFrequent logfile switches are occurring.
- BRedo is generated faster than LGWR can write it out.
- CFrequent commits or rollbacks are taking place in the application.
- DFrequent incremental checkpoints are taking place in the database.
How the community answered
(24 responses)- A13% (3)
- B4% (1)
- C79% (19)
- D4% (1)
Community Discussion
No community discussion yet for this question.