SURESHKUMAR.NET FORUMS - View Single Post - What will happen after commit statement ?

mymailbox.21 · 13-03-08, 05:28 PM

small correction in your statement ajith.

when commit occurs, first LGWR(log writer) writes the redo entries from redo log buffer cache to redo log files in the database.

then DBWR(database writer) writes the dirty blocks or dirty buffers from write list of database buffer cache to corresponding datafiles.

13-03-08, 05:28 PM	#3 (permalink)
mymailbox.21 Junior Member Join Date: Mar 2008 Age: 25 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What will happen after commit statement ? small correction in your statement ajith. when commit occurs, first LGWR(log writer) writes the redo entries from redo log buffer cache to redo log files in the database. then DBWR(database writer) writes the dirty blocks or dirty buffers from write list of database buffer cache to corresponding datafiles.