Re: *Measuring sql performance (elapsed time and scalability) by number of logical reads

  • From: "bill thater" <shrekdba@xxxxxxxxx>
  • To: cary.millsap@xxxxxxxxxx
  • Date: Wed, 3 May 2006 10:20:13 -0500

On 5/3/06, Cary Millsap <cary.millsap@xxxxxxxxxx> wrote:

I agree. And that's what we get on the PARSE, EXEC, FETCH, UNMAP, SORT
UNMAP, and STAT lines. It's not presented in a lot of detail, but it's a
tradeoff between detail and measurement intrusion.

There's certainly more detail available; for example, events 10104,
10200, etc., but the measurement intrusion is significantly greater for
some of those events than it is for 10046.

is it great enough to skew the results?


-- -- Bill "Shrek" Thater ORACLE DBA shrekdba@xxxxxxxxx ------------------------------------------------------------------------ "All the girls say Save a horse, ride a cowboy." -- //www.freelists.org/webpage/oracle-l


Other related posts: