Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
- From: Ls Cheng <exriscer@xxxxxxxxx>
- To: mm@xxxxxxxxxxxxxxxx
- Date: Tue, 13 Nov 2012 21:00:50 +0100
Hi
I also thought of that and in fact one statement was called by another but
the rest doesnt seem the case:
See following data and attention to the module, they are all different so
cant be double counting:
* CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash
Value
---------- ------------ ---------- ------ ---------- ---------------
----------
4407.08 20,294 0.22 51.6 10006.66 1,228,369,784
3703299877
Module: JDBC Thin Client
3943.14 157,316 0.03 46.2 6915.60 1,034,202,723
1127338565
Module: sel_ancomm_vss_06.tsk@c2aixprod (TNS V1-V3)
2358.20 269,711 0.01 27.6 4095.76 1,508,308,542
1995656981
Module: sel_zuteiler_alert.tsk@c2aixprod (TNS V1-V3)
1305.21 9,932 0.13 15.3 2483.90 331,327
1310406159
Module: sel_verwaltung.tsk@c2aixprod (TNS V1-V3)*
These 4 statements already adds up to 12013 CPU Seconds and the DB CPU is
8464 seconds.
Also look this text from top sql statmenet section:
-> Total DB CPU (s): 8,539
*-> Captured SQL accounts for 232.5% of Total DB CPU*
-> SQL reported below exceeded 1.0% of Total DB CPU
Capture SQL is 232% DB CPU! How can this be possible?
Thanks
--
//www.freelists.org/webpage/oracle-l
Other related posts:
