Re: Statspack Interpretation

From: <mccmx_at_hotmail.com>
Date: 20 Apr 2006 07:00:15 -0700
Message-ID: <1145539293.459660.183400@j33g2000cwa.googlegroups.com>

Thats a fair point....

I've been looking into the code for the STATSPACK procedure and the spreport.sql. They both seem to back up what Jonathan is saying... i.e. the 'elapsed time' is the total elapsed time for a given SQL statement during the snapshot interval.

However the top 10 SQLs ordered by physical reads are doing over 50% of the total number of physical reads, but only accounting for 10% of total I/O wait times..

That doesn't sound right....

Matt Received on Thu Apr 20 2006 - 09:00:15 CDT