Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> statspack comment is needed
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
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 2392.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