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 block cache algorithm and cache hit or not

Re: data block cache algorithm and cache hit or not

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Fri, 28 Sep 2001 01:01:18 +0100
Message-ID: <9p0i0g$egb$1@phys-ma.sol.co.uk>


That is correct

"mako" <makoml_at_jcom.hone.ne.jp> wrote in message news:d7Hs7.1817$kn.217964_at_news1.rdc1.ky.home.ne.jp...
> Thank you Lawrence,
> Your reply is very helpful, and I understand at last.
>
> The Conclusion I understand is ...
> When DML was given, foreground processe will cache result sets into
buffer,
> and second time query will have a higher hit ratio if these result was not
> aged.
> If result sets are large, these results will placed in LRU and will be
aged
> soon.
>
>
> > No need to apologise, your English is very good... my Japanese is
> > non-existent save for a few Karate terms.
>
> Great!
>
> Mako
>
>
Received on Thu Sep 27 2001 - 19:01:18 CDT

Original text of this message

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