| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statspack Report Help, Bursts of Activity, Amaze Your Friends ...
Yes, the post_transaction procedure would use most of the CPU, but nmon
shows the CPU is idle almost all the time. So while this procedure uses
most of the cpu when cpu is being used, most of the time the cpu is just
idle.
-----Original Message-----
From: Ryan [mailto:ryan.gaffuri_at_cox.net]
Sent: Friday, February 13, 2004 6:42 PM
To: oracle-l_at_freelists.org
Subject: Re: Statspack Report Help, Bursts of Activity, Amaze Your
Friends...
I could be reading this wrong, but it sure looks like this is using 75% of your CPU.
50,356,857 1,154 43,636.8 75.8 2236.12 3541.02
1143193881
Module: JDBC Thin Client
BEGIN :1 := hsd_batch.post_transaction(:2,:3,:4); END;
What does it do?
----- Original Message -----
From: "Post, Ethan" <Ethan.Post_at_ps.net>
To: <oracle-l_at_freelists.org>
Sent: Friday, February 13, 2004 6:44 PM
Subject: Statspack Report Help, Bursts of Activity, Amaze Your Friends...
> http://www.geocities.com/epost1/sp_1805_1808.txt
>
>
> I am stumped here. I am benchmarking some software and this is what I am
> seeing. When running nmon on AIX 24 CPU box, all CPU's are idle, then we
> see bursts of activity on all CPU's to 100%. In the database I see 40
> sessions coming in via JDBC Thin Client processing transactions, all idle,
> then all have serious bursts of activity. As you can see the most
> significant wait it CPU, but CPU's are Idle!!
>
> Stumpppeddd...
>
> nmon also shows that the disks are all idle, then experience bursts of
> activity. The disk system is an EMC, older model with not enough channels
> or controllers (not a disk guy), but I don't see any IO waits and I don't
> see anything in nmon.
>
> If you can spot something obvious in my Statspack report that I am missing
I
> would appreciate it.
>
> Event 10046 trace on a session also doesn't show it having any significant
> waits.
>
> My fear is we have a disk, OS or hardware configuration issue. I don't
have
> a lot of access to the admins of this box.
>
> Thanks!
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Feb 13 2004 - 21:21:41 CST
 |
 |