Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data storage question
You are right. Caching is done only for smal Lookup tables which are
accessed frequently and not for any Big Objects as they will have
negative impact by flushing out wanted buffers..
-Thiru
Steve Haynes wrote:
> In article <7ps6of$cp1$1_at_autumn.news.rcn.net>, Jerry Gitomer
> <jgitomer_at_hbsrx.com> writes
> >queries). In fact if you are using Oracle 8 you can lock your
> >indexes in RAM and your system will fly.
> >
> How?, this is new one to me.
>
> Assuming alter index keep or something, what if the
> indexes are too large for ram? - warehouses etc.
> Won't you lose any benefit in swapping?
>
> This sounds best left to to memory algorithms as a
> first reaction. Can anyone enlighten me?
>
> Thanks,
> Steve
> --
> Please remove nospam from my address to Reply.
Received on Tue Aug 24 1999 - 09:16:21 CDT