Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pinning objects in cache
Chris, have you ran explain plan on the SQL causing the full table
scan? How large is this table? And Mladen was right the Oracle
version is important information. With version 9 or 9.2 Oracle changed
the manner in which it determines which blocks to flush from the buffer
cache so that table blocks do not automatically go to the soon to be
flushed end of the LRU chain. This means there is less need to
consider creating a keep buffer pool.
HTH -- Mark D Powell -- Received on Tue Nov 15 2005 - 09:31:48 CST