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" <[EMAIL PROTECTED]> > Date: 2003/12/23 Tue PM 01:59:32 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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----- > [EMAIL PROTECTED] > 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: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).