Re: Statspack Interpretation

<mccmx_at_hotmail.com> wrote in message
news:1145534692.592082.247830_at_i40g2000cwc.googlegroups.com...
> Oracle 9.2.0.6 EE on Win 2K
>
> Anyone know if the following "Elapsd Time(s)" and "CPU Time(s)" are
> 'per execution' or total for the snapshot interval:
>
> CPU Elapsd
> Physical Reads Executions Reads per Exec %Total Time (s) Time (s)
> Hash Value
> --------------- ------------ --------------
> ------ -------- --------- ----------
> 73,467 2 36,733.5 6.8
> 4.66 103.91 1599906678
> Module: sqrw.exe
> SELECT DISTINCT fr1.emplid, fr1.empl_rcd, fr1.hrmssi_id, to_char
> (fr2.hrmssi_fld_grp,'000') from ps_hrmssi_empldat fr1, ps_hrmss
> i_details fr2 where fr1.hrmssi_fld_flag1 = 'Y' and fr1.hrmssi_
> out_fld = fr2.hrmssi_out_fld and fr1.hrmssi_id = 'TMMF001' and
> fr2.hrmssi_id = fr1.hrmssi_id and fr2.hrmssi_fld_grp > 0 an
>
> Cheers
>
> Matt
>

Should be for the period, with the usual warning about events starting before the start of the period, and ending in the period and recording their total time to the ending period rather than 'sharing' it across periods.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html