Re: RE: does CPU usage matter when scaling?

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