Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: *Measuring sql performance (elapsed time and scalability) by number of logical reads

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

From: bill thater <shrekdba_at_gmail.com>
Date: Wed, 3 May 2006 10:20:13 -0500
Message-ID: <a1d204910605030820p37a0d28escfae26768762e9f5@mail.gmail.com>


On 5/3/06, Cary Millsap <cary.millsap_at_hotsos.com> 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_at_gmail.com
------------------------------------------------------------------------
"All the girls say
Save a horse, ride a cowboy."
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 03 2006 - 10:20:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US