Re: RE: does CPU usage matter when scaling?

High LIO's require create a lot of latch activity, which can result in high CPU usage if there is latch contention, so reducing LIO's will reduce CPU usage.

Jared

On Tue, 2003-12-23 at 12:34, ryan_oracle_at_cox.net wrote:
> the cpu right now is high because they are not-using bind variables. Which is being fixed. So I was ignoring CPU usage.
>
> Ive read that article. I dont remember any CPU material in there. I just focused on LIOs and didnt realize I needed to monitor CPU. However, high LIOs will lead to high CPU right? So in order to tune, wouldnt I concentrate on lowering LIOs and as a result that will bring down CPUs. I take CPU as a consequence of something, but not as a means to an ends.
>
> or am I wrong here?
> >
> > From: "Cary Millsap" <cary.millsap_at_hotsos.com>
> > Date: 2003/12/23 Tue PM 01:59:32 EST
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: RE: does CPU usage matter when scaling?
> >
> > Ryan,
> >
> > Take a look at "Why you should focus on LIOs instead of PIOs" at
> > www.hotsos.com/e-library. If you have access to the book "Optimizing
> > Oracle Performance," check out chapter 9.
> >
> > If an application is written not to crash into some kind of
> > serialization barrier (latch free, enqueue, etc.), then the thing it
> > *should* get stuck spending most of its time doing is consuming CPU
> > service. Applications that consume less CPU service scale better than
> > apps that consume more. I would then say that it's FANTASTIC that your
> > software engineers are looking at CPU consumption as they design, build,
> > and test their code.
> >
> >
> > Cary Millsap
> > Hotsos Enterprises, Ltd.
> > http://www.hotsos.com
> >
> > Upcoming events:
> > - Performance Diagnosis 101: 1/27 Atlanta
> > - SQL Optimization 101: 2/16 Dallas
> > - Hotsos Symposium 2004: March 7-10 Dallas
> > - Visit www.hotsos.com for schedule details...
> >
> >
> > -----Original Message-----
> > ryan_oracle_at_cox.net
> > Sent: Tuesday, December 23, 2003 12:39 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > The softwrae engineers are measuring CPU usage. I usually ignore this
> > and dont care about that value. I dont have any docs on it. anyone have
> > any docs on this? or am I wrong?
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: <ryan_oracle_at_cox.net
> > INET: ryan_oracle_at_cox.net
> >
> > 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).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <ryan_oracle_at_cox.net
> INET: ryan_oracle_at_cox.net
>
> 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: Jared Still
  INET: jkstill_at_cybcon.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).