Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: pinning objects in cache

Re: pinning objects in cache

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 15 Nov 2005 14:46:09 GMT
Message-Id: <pan.2005.11.15.14.46.08.740516@sbcglobal.net>


On Tue, 15 Nov 2005 06:11:51 -0800, chris b wrote:

> Please could anyone advise on the best way of ensuring an object stays
> within memory.
>
> I have a situation where frequent full table scans are being executed
> on the same table
>
>
> cheers
> Chris B

Well, if I were you, I'd start with telling us your Oracle version. Parameters differ, 9i has BUFFER_POOL_KEEP, 10.2 has DB_KEEP_CACHE_SIZE.

-- 
http://www.mgogala.com
Received on Tue Nov 15 2005 - 08:46:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US