Friday, December 26, 2008

When Does LGWR Write?

Log Writer writes from redo log buffer to the redo log files when one of the following occurs:
  • Every 3 seconds
  • A user commits a transaction
  • A redo Log Buffer is one-third full
  • Redo Log Buffer contains 1 MB worth of redo information
  • Before DBWn process whenever a database checkpoint occurs

No comments:

Post a Comment