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, [EMAIL PROTECTED] 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" <[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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
