Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers

*Host Name             Platform                CPUs Cores Sockets   Memory

~~~~ ---------------- ---------------------- ----- ----- -------
------------
     c2xxxprod        AIX-Based Systems (64-    16     4       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)

----------------------------------------- ------------ ----------- ------
------
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

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

--
http://www.freelists.org/webpage/oracle-l