From: Vitaly Sikolenko <vsikolen@ru.oracle.com>
Subject: Re: How to allocate table in memory during application lifetime .
Date: 1997/08/08
Message-ID: <33EB0A7A.E6E78EE8@ru.oracle.com>#1/1
References: <33E88BBA.48136C03@elbit.co.il>
To: Haim Stots <stots@elbit.co.il>
X-Priority: 3 (Normal)
Organization: Oracle C.I.S.
Reply-To: vsikolen@ru.oracle.com
Newsgroups: comp.databases.oracle.server



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

  If you have 7.3 or later versions try to use PL/SQL tables.

--
Vitaly Sikolenko                  Senior Sales Consultant
                                  Server & Gateways
ORACLE C.I.S.
Moscow Russia                      E-mail: vsikolen@ru.oracle.com

The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.