What does this event indicate?

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?

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?

A.
Frequent logfile switches are occurring.

B.
Redo is generated faster than LGWR can write it out.

C.
Frequent commits or rollbacks are taking place in the application.

D.
Frequent incremental checkpoints are taking place in the database.



Leave a Reply 0

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