You can use the CACHE option with the CREATE TABLE or ALTER TABLE commands.
Use of CACHE option may improve the performace for fairly static tables.
Once loaded into the buffer cache, datablocks of cached tables are placed
at the most recently used end of the LRU list. Because of this, blocks of
cached tables will stay in SGA for longer period (How long I don't know).
--
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX
Tony A. Carey <tcarey_at_ent.mrj.com> wrote in article
<32E4C9AE.77B5_at_ent.mrj.com>...
> 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 Wed Jan 22 1997 - 00:00:00 CST
