Re: Caching in RAM

to tell oracle to put a table into the SGA run the following:

ALTER TABLE Table_Name Cache;

This will not guarantee it will stay in the SGA. It will keep the table in the SGA for as long as possible. The next time you startup the instance it will place the table into the SGA until you tell it otherwise.

Greg Vitetzakis.
DBA Michael Will de Laforcade <mwill_at_dris.com> wrote in article <6gdhmk$app$1_at_news0-alterdial.uu.net>...
> Is there any way to tell the server to cache a certain table in RAM. We
 run
> a process 4 times a day that would really benefit if the table could be
> cached and then moved out when done.
>
> Michael.
>
>
>
>
>
Received on Wed Apr 08 1998 - 00:00:00 CDT