Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LGWR write

AKPTJan 18 2012 — edited Jan 19 2012
Hi,

Oracle Verson : Oracle Database 10g Release 10.2.0.4.0
OS:Windows XP

In Oracle document it is mentioned that:
When a user issues a COMMIT statement, LGWR puts a commit record in the redo log buffer and writes it to disk immediately, along with the transaction's redo entries . The corresponding changes to data blocks are deferred until it is more efficient to write them. This is called a fast commit mechanism.
Now my query is:
After commit LGWR writes commit record on disk.Does LGWR also writes commit records in Redo log?
This post has been answered by CKPT on Jan 18 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2012
Added on Jan 18 2012
#general-database-discussions
3 comments
309 views