RE: statspack snapshots cause 3-4 sec of 100% CPU utilization

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