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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment