Boris, I missed the second part of your question... apologies. If your SGA/Shared pool was partly swapped out, I would assume that you might see an increased 'system' utilization. Did you check 'sar -q' and 'sar -r' at the same time to check? I haven't used mandrake - just wondering if the CPU cycles used for memory access are being counted against the wrong pigeonhole..
John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve; Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -----Original Message----- > From: Boris Dali [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 7:45 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: statspack snapshots cause 3-4 sec of 100% CPU utilization > > > Thanks, John. > > Any insight as to why is it primarily the system mode > CPU? I've seen high system mode CPU utilization in > non-Oracle stuff (like NFS), but for Oracle I thought > it should be primarily user mode? > > Does Oracle's "CPU used by this session" represents > user-, kernel-mode or both? And what about "c" in the > raw traces? > > Thanks John, > Boris Dali. > > --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > > Boris, > > > > The default statspack snapshot is at level 5, which > > collects Top SQL (by > > buffer and Phys reads, etc.) from the Shared pool, > > and that would cause > > significant latching for a large shared pool which > > in turn results in a high > > CPU usage. You could try a level 0 snapshot and look > > at the CPU utilization > > at that time... > > > > John Kanagaraj > > Oracle Applications DBA > > DBSoft Inc > > (W): 408-970-7002 > > > > Disappointment is inevitable, but Discouragement is > > optional! > > > > ** The opinions and statements above are entirely my > > own and not those of my > > employer or clients ** > > > > > > > -----Original Message----- > > > From: Boris Dali [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, June 05, 2003 2:05 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: statspack snapshots cause 3-4 sec of 100% > > CPU utilization > > > > > > > > > As subject line indicates standard (level 5) > > snapshots > > > make "vmstat 1" or "sar -u 1 100" show 100% CPU > > > utilization (75% system mode) for about 3 seconds. > > > > > > Is this normal? Is statspack that brutal on CPU? > > And > > > why would that be a system mode primarily? > > > > > > Environment: > > > > > > Oracle 9.2.0.2 on Mandrake 9.0 > > > (2.4.19-16mdkenterprise) > > > 2.4GHz uniprocessor P4 box, 1GB SDRAM > > > > > > TIA, > > > Boris Dali. > > > > > > > > > > > > ______________________________________________________________ > > > ________ > > > Post your free ad now! http://personals.yahoo.ca > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.net > > > -- > > > Author: Boris Dali > > > 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: John Kanagaraj > > 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). > > ______________________________________________________________ > ________ > Post your free ad now! http://personals.yahoo.ca > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Boris Dali > 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: John Kanagaraj 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).
