Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to allocate table in memory during application lifetime .

Re: How to allocate table in memory during application lifetime .

From: Eric & Carole Kamradt <kamradt_at_inconnect.com>
Date: 1997/08/08
Message-ID: <33EB1220.ABF03F6C@inconnect.com>#1/1

Vitaly Sikolenko wrote:

> Haim Stots wrote:
>
> > Hello ,
> > What is the best way if any to make sure that the table is resident
 in
> >
> > the memory,
> > i'm sick and tired of hearing my disk roaring "GRRRRRRRRRRRRRRRR"
> > the table is about 500K and i'm accessing it about 1000 times in a
> > min.
> >
> > Sincerely yours
> > Stots
> >
> > Please reply to: stots_at_elbit.co.il
>

You might try
ALTER TABLE <tableName> CACHE;

Oracle recommends this for very small, frequently used tables. To undo this try
ALTER TABLE <tableName> NOCACHE;

Good luck

Eric Kamradt
hm: (801) 567-0912
mailto: kamradt_at_inconnect.com
http://www.inconnect.com/~kamradt/resume.html Received on Fri Aug 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US