Re: CACHE/NOCACHE and _SMALL_TABLE_THRESHOLD

From: yong huang <yong321_at_yahoo.com>
Date: Fri, 20 Oct 2000 12:52:14 -0700 (PDT)
Message-Id: <10655.119882@fatcity.com>

Hi, Jay,

Steve Adams seems to have the answer for you at http://www.ixora.com.au/q+a/cache.htm. My interpretation of what he says is that, if both NOCACHE is set and the table size is below
_SMALL_TABLE_THRESHOLD, the table will be cached at the MRU end of the LRU list
once it's full scanned, and the parameter _SMALL_TABLE_THRESHOLD will be incremented.

Yong Huang
yong321_at_yahoo.com

you wrote:

Does Oracle apply CACHE/NOCACHE option along with the _SMALL_TABLE_THRESHOLD parameter to determine whether to place data blocks at the MRU or LRU end of the buffer cache? Is _SMALL_TABLE_THRESHOLD parameter applicable in Oracle8? If Oracle8 uses both CACHE/NOCACHE option and _SMALL_TABLE_THRESHOLD parameter, then which one takes precedence? For example, if a table is created with NOCACHE, but it's size is less than _SMALL_TABLE_THRESHOLD, then how Oracle is going to determine whether to place it at the LRU or MRU end of the buffer cache?

Thanks,
Jay

---

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. Received on Fri Oct 20 2000 - 14:52:14 CDT