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: Buffer cache statistics (ratios) and CBO SQL optimization?

Re: Buffer cache statistics (ratios) and CBO SQL optimization?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 29 Dec 2003 18:57:31 -0000
Message-ID: <3ff07919$0$25673$cc9e4d1f@news.dial.pipex.com>


well they do until you saturate it (30 mins after boot :( ).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
news:3ff03390$0$18692$afc38c87_at_news.optusnet.com.au...

> That is assuming of course your I/O device
> doesn't itself have a cache. Which most
> RAID boxes and disk farms nowadays have.
> So the 1:1 comparison rings true in many cases...
>
> --
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3feffd79$0$13349$ed9e5944_at_reading.news.pipex.net...
> > >
> > > I remember seeing a hotsos article where it is argued currently LIOs
> > > are almost equally expensive as PIOs
> >
> > I'd be a little surprised if they argued that the two were almost
equally
> > expensive, I'm pretty sure that the figure is something like 20-100
times
> > which is significantly smaller than the figures commonly given but not
> > almost equal.
> >
>
>
Received on Mon Dec 29 2003 - 12:57:31 CST

Original text of this message

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