Problem solve
Get help with specific problems with your technologies, process and projects.
How does the Oracle LGWR write to online redo log files?
Learn how the Oracle LGWR writes both uncommitted and committed transactions from the log buffer to the online redo log files in this tip from Oracle expert Brian Peasland.
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
How does the Oracle LGWR write the log buffer to the online redo log? Does it write out the entire log buffer or just the committed records? If it writes out just the committed records, would it increase 'log file parallel write' time for using a large log buffer?
LGWR does write change records in the log buffer to the online redo log files. When a user issues a COMMIT, the COMMIT is not complete until the change records have been written to the online redo logs. However, large transactions may fill the
log buffer before a COMMIT is issued. For this reason, LGWR will write to the online redo logs if the log buffer becomes one-third full or after there is 1MB of new redo in the log buffer, or every 3 seconds, or before DBWn writes to the database files. As you can see, LGWR does not write just committed transactions, it may write uncommitted ones as well.
This was last published in November 2009
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments