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