What does this imply?

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?

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?

A.
DBWR is slow.

B.
LGWR is slow due to slow I/O.

C.
Redo log buffer size is insufficient.

D.
The application might be committing frequently.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

log file sync = > commit

D is right