RE: Can Someone shed some light on this Pls

I do not know the name of the book but it was on 8i I was just reading a couple of nights ago at a book
store on this very subject. It clearly stated that there is a write list used with the same purpose as you
described. I would like to know also. If not then this book is clearly wrong. I think the book may have been
the Oracle 8i OCP for DBA and B&R.

Rick

> -----Original Message-----
> From: Vivek [SMTP:Vivek_at_1800FLOWERS.com]
> Sent: Wednesday, January 10, 2001 6:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Can Someone shed some light on this Pls
>
> Pre 8.0 there was the LRU list, LRUW list and the Check point queue list.
> Whenever a block is dirtied (and according to a algorithm) ultimately the
> block was shifted to the LRUW list so that the DBWR can write the buffer
> out and the Checkpoint queue was populated when a check point is happening
> and the list of blocks that are to written out is made up in the check
> point
> queue. I was told that in 8.0 onwards even though the LRUW list exists its
> no longer used and the Check point queue list is used instead by te DBWR
> to
> write the blocks. This helps DBWR writes the blocks in the sequence they
> were dirtied.
>
> Can someone shed some light on how a dirty block reaches the DB file in
> 8.0
> version and above or Am I missing something?
>
> Thanks in advance
>
> Vivek
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Vivek
> INET: Vivek_at_1800FLOWERS.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jan 10 2001 - 06:05:35 CST