CACHE/NOCACHE and _SMALL_TABLE_THRESHOLD

Hi All,

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, Received on Thu Oct 19 2000 - 11:20:22 CDT