RE: low buffer hit ratio

From: Gurelei <gurelei_at_yahoo.com>
Date: Fri, 15 Nov 2002 06:34:14 -0800
Message-ID: <F001.00504330.20021115063414@fatcity.com>

Dennis:

OEM calculates the BHR for all the queries. I presume it is being calculated using the same formula but only using the disk reads and buffer gets for the single query. I started with this query because it has the lowest bhr in the database.
--- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Gurelei - What do you mean by a low buffer hit ratio
> for a SQL statement?
> BHR is measured for the system, not for an
> individual query.
> Why have you singled this query out for
> attention? Are there complaints
> about its performance? Does it hit more blocks that
> other queries on your
> system?
>

Gene

---

Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gurelei
  INET: gurelei_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Nov 15 2002 - 08:34:14 CST