Mogens
DENNIS WILLIAMS wrote:
Boris - I'm not surprised in your results. I wouldn't describe STATSPACK as
"brutal", but it is a significant hit, so you wouldn't want to start doing
snaps at 1 second intervals. STATSPACK does collect a LOT of data, and you
can adjust the amount of data collected with the level if you feel the need
to reduce the brutality. If you find you only need a few pieces of
information, you could write your own routines to collect just what you
need.
I have no idea why your system mode sees an impact. Perhaps someone who
has more systems experience can venture a guess. You might try several
measurements just in case you caught the system at a bad moment.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message----- Sent: Thursday, June 05, 2003 4:05 PM To: Multiple recipients of list ORACLE-L
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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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).