Re: statspack comment is needed

hopehope_123 wrote:
> 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 ?

see http://www.jlcomp.demon.co.uk/statspack_01.html

jg

--
@home.com is bogus.
Put the CFO in charge and tell people you are continuing to hire great
people.  Riiiiight.
http://www.signonsandiego.com/uniontrib/20061207/news_1b7yahoo.html