Wednesday, July 11, 2007

When Does Log Writer Write?

The LGWR background process writes to the current redo log group whenever one of the
following database events occurs:
 Every three seconds.
 A user commits a transaction.
 The Redo Log Buffer is one-third full.
 The Redo Log Buffer contains 1MB worth of redo information.
 Before the DBWn process whenever a database checkpoint occurs.