I am Confused
598764Jul 14 2008 — edited Jul 15 2008Hi All
Three Questions :
1)
I had read that the DBWR is responsible for writing the Dirty blocks from Database Buffer Cache to the Database Files on disk.
Will it directly write to the Database files or it will first write to RedoLog Files. ?
-----------------------------------------------------------------------------------------------------------------
2)
Also, when will Oracle puts the data in RedoLog Buffer.Then LGWR will write the data in RedoLog Files, which process is responsible to write the data from redolog files to the Database Files.
-----------------------------------------------------------------------------------------------------------------
3)
Suppose i insert 10 new rows in a table. After writing the these new records in the Database Buffer cache, when will Oracle puts this data in the RedoLog buffer.
I read the documentation. Still i am confused.
Thanks