Re: LGWR vs DBWn

Peter wrote:

> If it is the LGWR that writes the redo logs into the redo log buffer
> then what writes the redo logs into the redo log files? A system
> process?

Hmmmm - a good question. Since you read the manuals enough to formulate the question, you could possibly read a bit further (maybe even the next paragraph) and formulate the answer.

So, what do YOU think? Why don't you propose a possible answer & back it up with your understanding or references to the docco. Use the "am I getting this right - here's how I think it works" method instead of the endless question method!

> If it is the user process that writes the datablocks into the db
> buffer cache, then what writes those dirty data buffers into the the
> datafiles? Is it the DBWn?

> Thanks

All of this information, and a lot more is available through courses, including online courses through Oracle University via http://otn.oracle.com, at a fairly reasonable fee. While I admire your persistance and your ability to ask questions - and the improvement in quality of questions over the past 3 weeks - I for one am tired of your attempt to do a free "Oracle-101 course" in the newsgroup. Received on Sun Jun 15 2003 - 20:05:26 CDT