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. See Chapter 10 for more
information on checkpoints.
Tuesday, March 18, 2008
When Does LGWR Write?
Subscribe to:
Post Comments (Atom)
1 comment:
hi deepthi, i am harsh .......... nice blog and its very much use full to me, thank u for providing such a excellent subj for us and one samll request " could u pls add perfromance and tuning topic in ur blog so that it will became a complete dba package for every one " once again thanks for providing such a useful subj
Post a Comment