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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 25 Dec 2003 00:34:50 +0100
Message-ID: <mj8kuvsgb5dbdoklfrj48aiuk69vui5k8j@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

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Dec 24 2003 - 17:34:50 CST

This message: [ Message body ]
Next message: Geomancer: "Re: buffer hit cache ratio should be ..."
Previous message: joes: "how to: oracle full text search over multiple columns"
In reply to: Daniel Roy: "Re: Buffer cache statistics (ratios) and CBO SQL optimization?"
Next in thread: Ryan: "Re: Buffer cache statistics (ratios) and CBO SQL optimization?"
Reply: Ryan: "Re: Buffer cache statistics (ratios) and CBO SQL optimization?"
Reply: Niall Litchfield: "Re: Buffer cache statistics (ratios) and CBO SQL optimization?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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