RE: Cache a table

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 21 Oct 2003 04:59:26 -0800
Message-ID: <F001.005D3DC3.20031021045926@fatcity.com>

Mike:

I guess we are aware there is no concept of LRU or MRU in current versions of Oracle and I don't think CACHE option will influence the behavior. With the new algorithm the MFU blocks are already in the hot end (unless they are read using CR read in that case they will be in cold end since we set the _db_aging_freeze_cr to TRUE) and we don't need to cache the blocks explicitely.

You can monitor the behavior of this using the X$BH (espicially the last two columns TCH and TIM).

---

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 Tue Oct 21 2003 - 07:59:26 CDT