Re: 9iR2 Oracle SGA Memory

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 26 Feb 2003 03:18:50 -0800
Message-ID: <F001.00559C5E.20030226031850@fatcity.com>

Robert:

There is no single LRU (if you want to call LRU lists) in Oracle9i. There are 7-8 replacement lists in 9i and they are like LRU, LRUW, CKPT Q lists (like thread checkpoint, file checkpoint and recovery checkpoint lists), LRU list for OPS/RAC ping blocks, and some other lists.

And also each list will internally have 2 lists (MAIX and AUX). THe dirty, replaceable buffers will be linked to the AUX lists and DBWR will start writing from the AUX lists when the MAIN lists are in normal operation.

With these numerours lists there are some priorities assigned to each of the lists during writes and buffers from LRU Ping lists will have the highest write priority and normal aging buffers will have the lowest priority.

So coming back to your original question, The LRU list is still there, but at a little bit more detailed level.

KG

• Freeman Robert - IL <FREEMANR_at_tusc.com> wrote:
  > Ok... with the changes to the "touch point" memory management
  > methodology in
  > 9i, I found myself wondering, Does Oracle still scan the equivalent
  > of the
  > LRU list to find free blocks,
  > and if so is it still called the LRU list, or has the name of this
  > list been
  > changed along with the architecture changes or has the architecture
  > for
  > assigning free memory changed completely? Anyone want to share some
  > knowledge?
  >
  > RF
  >
  > Robert G. Freeman
  > Technical Management Consultant
  > TUSC - The Oracle Experts www.tusc.com
  > 904.708.5076 Cell (It's everywhere that I am!)
  > Author of several books you can find on Amazon.com!
  >
  >
  

  ---

Have a nice day !!

---

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Feb 26 2003 - 05:18:50 CST