Statspack Interpretation

From: <mccmx_at_hotmail.com>
Date: 20 Apr 2006 05:04:52 -0700
Message-ID: <1145534692.592082.247830@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 Received on Thu Apr 20 2006 - 07:04:52 CDT