Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pinning objects in cache
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.comReceived on Tue Nov 15 2005 - 08:46:09 CST