Re: Statspack Report Help, Bursts of Activity, Amaze Your Friends...

  • From: "Ryan" <ryan.gaffuri@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 13 Feb 2004 19:41:52 -0500

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@xxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2004