"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:mj8kuvsgb5dbdoklfrj48aiuk69vui5k8j_at_4ax.com...
> On 24 Dec 2003 14:21:04 -0800, danielroy10junk_at_hotmail.com (Daniel
> Roy) wrote:
>
> > Oracle experts generally tend to try to minimize the number of
> >physical block reads because it's well known that they are much more
> >"expensive" than logical ones (I heard all kinds of numbers on how
> >much more expensive they are, ranging from 1400 to 10000
>
>
> 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.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Dec 29 2003 - 04:10:01 CST
