Database Tuning (MOSC)

MOSC Banner

How is it possible for the "log file sync" to be much higher in latency time (4ms) vs. the LGWR late

edited May 23, 2019 8:52AM in Database Tuning (MOSC) 3 commentsAnswered

Greetings,                                                                                                                                      

  

In an AWR report for an hour period in the daytime, I see that “log file sync” has an average latency of 4ms while the LGWR has an average latency of 1.68ms.

  

 

Is LGWR's only job to write log buffers to log file which is a "log file sync"?

thanks for your help!

Message was edited by: 3265461

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center