Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> statspack comment is needed

statspack comment is needed

From: hopehope_123 <hopehope_123_at_yahoo.com>
Date: 7 Dec 2006 13:56:13 -0800
Message-ID: <1165528573.149103.291990@j72g2000cwa.googlegroups.com>


Hi Gurus ,

              Snap Id     Snap Time      Sessions Curs/Sess Comment
            --------- ------------------ -------- ---------
-------------------
Begin Snap:      2428 07-Dec-06 16:10:00       96      12.2
  End Snap:      2429 07-Dec-06 17:10:00      167      14.4
   Elapsed:               60.00 (mins)


Top 5 Timed Events



% Total
Event                                               Waits    Time (s)
Ela Time
-------------------------------------------- ------------ -----------
--------
CPU time                                                        5,551
 69.62
db file sequential read                            37,573         689
  8.65
log file parallel write                            76,392         406
  5.10
log file sync                                      19,417         377
  4.72
db file scattered read                             16,016         239
  2.99

This is a 60min. interval output of statspack. It says 5551 second is spent on cpu. 5551 sec. is greater than 60min. What does this value mean? How can i comment about ?Is it worth the effort to deal with the cpu time ?

Kind Regards,
hope Received on Thu Dec 07 2006 - 15:56:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US