Re: Pinning a Table?

From: David M Walker <davidw_at_datamgmt.com>
Date: Sun, 27 Sep 1998 21:53:08 +0100
Message-ID: <360EA5B4.45618860@datamgmt.com>

Chris wrote:
> I know that you can pin a PL/SQL object in the shared pool, but is
> there anyway to pin a table in memory? If I have a table that I want
> to make sure is always in memory, how do I accomplish this task?

Only if it is small, then you can set the small_table_threshold to be bigger and it along with all other tables of the same or smaller size would remain in the SGA once queried

davidw Received on Sun Sep 27 1998 - 15:53:08 CDT