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: Data storage question

Re: Data storage question

From: tmgn <tmgn_at_excite.com>
Date: Tue, 24 Aug 1999 10:16:21 -0400
Message-ID: <37C2A935.59ED2090@excite.com>


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

Original text of this message

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