info regarding redo file and data file

[anandkl]

Hi friends,
when does the redo buffer gets written to redo log file and what are the parameter that needs to be set for this to happen.Similarly when does the info in the database buffer cache is written to datafiles and what are the parameters that need to be set.And the does dirty buffers contain only commited data or both commited as well as non-commited.

cheese
anandkl

[sjadhavdba]

in case of database buffer cache - DBWR writes into data files and redo buffer - LGWR writes into redo files.

for more information go to
http://otn.oracle.com/docs/products/...procs.htm#6162

u'll all doubts will be cleared.

[anandkl]

i know that DBWr writes buffers from database base buffers and LGWR writes buffers from redo log buffer.But what i wanted to know is when the info in the redo log buffer is written by LGWR and when the changes are commited when are they written to datafiles and similarly when the DBWr writes the data buffers to datafiles.


cheese
anandkl

[marist89]

Originally posted by sjadhavdba
http://otn.oracle.com/docs/products/...procs.htm#6162

Check the link, it's right in there...

[anandkl]

thanks friends,i got it.

cheese
anandkl