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

"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
>

not quite equal to... the argument is that PIOs are not always the be all and end all. I have a link to it in another post. Its a classic article.

>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Thu Dec 25 2003 - 07:01:53 CST