| 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...
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 -----------------------------------------------------------------Received on Fri Feb 13 2004 - 18:41:52 CST
 |
 |