RE: quick suggestions for tuning ?

Thanks, Dennis.

Prem, in particular, please go to http://www.hotsos.com/catalog and download the document called "Why you should focus on LIOs instead of PIOs."

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- Hotsos Clinic 101 in Denver, Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...

-----Original Message-----
DENNIS WILLIAMS
Sent: Monday, August 11, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L

Prem

   Head for http://www.hotsos.com and study their documents. Cary Millsap,
who is kind enough to participate on this list, has identified LIO as a key
performance issue.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, August 11, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.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).