Re: Pin a table in memory

From: Gillian Lezama <glezama_at_amoco.com>
Date: 1997/01/21
Message-ID: <5c37fh$4d0@cronkite.amoco.com>#1/1

The main reason that it is not staying in the SGA is because it is being aged out due to lack of space. An object or data cannot be aged out if it being referenced frequently. So, why do you want the data in there it is not being referenced continuously?

I guess it is a performance issue you are trying to by-pass. Gillian
glezama_at_amoco.com

In article <32E4C9AE.77B5_at_ent.mrj.com>, tcarey_at_ent.mrj.com says...
>
>To anyone who can help
>
>Is there anyway to force rows of an oracle table to remain resident in
>machine memory during the time in which the instance is running?
>
>Regards,
>
>Tony.
Received on Tue Jan 21 1997 - 00:00:00 CST