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: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 3 May 2006 17:14:57 +0200
Message-ID: <016f01c66ec4$57f8db10$1a03310a@MPILA9>


> 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.

Thank you very much!
I'll check them.

Regards,
Dimitre

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 03 2006 - 10:14:57 CDT

Original text of this message

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