From: Eric & Carole Kamradt <kamradt@inconnect.com>
Subject: Re: How to allocate table in memory during application lifetime .
Date: 1997/08/08
Message-ID: <33EB1220.ABF03F6C@inconnect.com>#1/1
References: <33E88BBA.48136C03@elbit.co.il> <33EB0A7A.E6E78EE8@ru.oracle.com>
To: vsikolen@ru.oracle.com
X-Priority: 3 (Normal)
Organization: Internet Connect, Inc. -- http://www.inconnect.com	
Newsgroups: comp.databases.oracle.server



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@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@inconnect.com
http://www.inconnect.com/~kamradt/resume.html