Re: quick suggestions for tuning ?

Thanks a lot Connor.
Apart from bind vars.,LIO is a big issue here.

54 million consistent gets.
does it mean that db_cache_size (700M) is small ?

any good docs or links regarding LIO and how to deal with it ?  

Can u explain me Connor ?

Regards,
Jp.

>From: Connor McDonald <hamcdc_at_yahoo.co.uk>
>Subject: Fwd: Re: quick suggestions for tuning ?
>Date: 10-08-2003 23:44:25
>Its not really rocket science here...
>CPU is at the top of the timed event - and what causes
>CPU (or is the most common cause) - logical I/O. 54
>million consistent gets later down in the report
>probably a bit of a giveaway there :-)
>Next section in the report is some nice queries that
>use up 4 or so million buffer gets. Good ones to
>start with... As you've already noticed, no bind
>variables.
>Then some other miscellaneous things - look at how
>much free memory you have in most of your pools "SGA
>breakdown difference" - might be able to use that
>better elsewhere.
>cheers
>connor

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