With absolutely no disrespect to Cary, I'd recommend
the original poster head to the Concepts guide before
heading to hotsos. Gotta walk before you run and all
that kind of stuff...
Cheers
Connor
- Cary Millsap <cary.millsap_at_hotsos.com> wrote: >
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).
>
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger
http://uk.messenger.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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 Tue Aug 12 2003 - 10:04:23 CDT