Re: quick suggestions for tuning ?

Thanx a lot Jared.

With due respect to all my GURUS on this list, i start reading the docs AGAIN.

Thanx and Regards,
Jp.

13-08-2003 05:46:32, Jared.Still_at_radisys.com wrote:
> From: Jared.Still_at_radisys.com
> Date: Tue, 12 Aug 2003 13:46:32 -0700
> I would say that is often the norm.
> I would not say that it is however desirable.
> What you need to do is ask yourself "What is the benefit
> of re-reading the data in the buffer over and over?"
> When a database has a high Buffer Hit Ratio it will also have a
> large number of LIO's, and the reason is poorly written SQL
> that reads the same data from the cache, over and over.
> There papers at hotsos.com that will explain this in detail.
> Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Prem Khanna J
  INET: jprem_at_kssnet.co.jp

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).