Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
- From: Ls Cheng <exriscer@xxxxxxxxx>
- To: Karl Arao <karlarao@xxxxxxxxx>
- Date: Wed, 14 Nov 2012 10:40:43 +0100
Hi Karl
here is the data
*Host Name Platform CPUs Cores Sockets Memory
(G)
~~~~ ---------------- ---------------------- ----- ----- -------
------------
c2xxxprod AIX-Based Systems (64- 16 4 0
67.0
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- ---------
------------------
Begin Snap: 8696 13-Nov-12 11:00:02 236 4.0
End Snap: 8697 13-Nov-12 12:00:03 237 4.1
Elapsed: 60.02 (mins) Av Act Sess: 6.4
DB time: 384.99 (mins) DB CPU: 142.31 (mins)
Top 5 Timed Events Avg
%Total
~~~~~~~~~~~~~~~~~~ wait
Call
Event Waits Time (s) (ms)
Time
----------------------------------------- ------------ ----------- ------
------
CPU time 8,464
51.9
PL/SQL lock timer 60 3,600 60005
22.1
log file sync 210,625 2,258 11
13.8
log file parallel write 239,374 631
3 3.9
enq: UL - contention 27,018 466
17 2.9
Time Model System Stats DB/Inst: YYY/YYY Snaps: 8696-8697
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % DB time
----------------------------------- -------------------- ---------
sql execute elapsed time 20,342.6 ########
DB CPU 8,538.6 ########
PL/SQL execution elapsed time 2,012.8 ########
parse time elapsed 95.8 ########
hard parse elapsed time 25.3 ########
sequence load elapsed time 16.5 ########
connection management call elapsed 8.9 ########
repeated bind elapsed time 4.1 ########
hard parse (sharing criteria) elaps 1.8 ########
PL/SQL compilation elapsed time 0.2 ########
Java execution elapsed time 0.1 ########
hard parse (bind mismatch) elapsed 0.0 ########
failed parse elapsed time 0.0 ########
DB time 23,099.5
background elapsed time 887.0
background cpu time 43.3*
TIA
--
//www.freelists.org/webpage/oracle-l
Other related posts:
