Skip to Main Content

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!

I am Confused

598764Jul 14 2008 — edited Jul 15 2008
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2008
Added on Jul 14 2008
18 comments
1,081 views