Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: *Measuring sql performance (elapsed time and scalability) by number of logical reads
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-lReceived on Wed May 03 2006 - 10:20:13 CDT
![]() |
![]() |