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: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Tue, 30 Dec 2003 01:02:55 +1100
Message-ID: <3ff03390$0$18692$afc38c87@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 - 08:02:55 CST

Original text of this message

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