Re: Pinning a Table?

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Sun, 27 Sep 1998 14:03:07 -0700
Message-ID: <6um8tc$cos@sjx-ixn5.ix.netcom.com>

How about caching the table in memory? By issuing alter table <tablename> cache;, you can cache the table in memory. But beware of your cache hit ration performance. If it is deterioating.. it may not be such a good idea after all!

Winnie

Chris wrote in message <360E6C96.9EBFD93A_at_reddogg.ne.mediaone.net>...
>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?
>
>Many thanks,
>Chris
>
Received on Sun Sep 27 1998 - 16:03:07 CDT