Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Buffer cache statistics (ratios) and CBO SQL optimization?
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...Received on Mon Dec 29 2003 - 08:02:55 CST
> >
> > 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.
>