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

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

  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_at_ru.oracle.com

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