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!

DBWR and LGWR functionalities

James AttardSep 15 2004 — edited Sep 16 2004
The Oracle database concepts document, states that:

DBWR - Database Writer is responsible for buffer cache management. The DBWR writes modified buffers (dirty buffers) to datafiles.

LGWR - Log Writer writes data from the log buffer to the online redo log files.


What I cannot understand is what type of data does the DBWR writes in the datafiles, since as it is stated, I have the idea that the DBWR and LGWR are writing the same data to the datafiles. Isn't the DBWR going against the principle of the existance of the redo logs if it writes directly to the datafiles???????

Please illuminate me as I'm stuck in trying to learn this bit. Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2004
Added on Sep 15 2004
6 comments
5,611 views