| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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!
 |
 |