| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can Someone shed some light on this Pls
Hi, Vivek,
I believe this LRUW list is what Oracle documentation simply calls the write list:
The buffers in the cache are organized in two lists: the write list and the least recently used (LRU) list. The write list holds dirty buffers, which contain data that has been modified but has not yet been written to disk...
The term LRUW was probably abandoned beginning with Oracle either 7.1 or 7.3.
I didn't find mention of LRUW in the book "Scaling Oracle 8i".
BTW, where do you see the phrase "checkpoint queue list"? I can't find it anywhere.
Yong Huang
yong321_at_yahoo.com
you wrote:
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?
 |
 |