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

There are 350+ of these so-called pseudo-error debugging events, all listed in ?/rdbms/mesg/oraus.msg.

The only catch is that this file is [still] not distributed in the Oracle for Windows distribution set. It's easy to copy it from a Linux installation, however.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba  

Hotsos Symposium 2007 / March 4-8 / Dallas Visit www.hotsos.com for curriculum and schedule details...

-----Original Message-----
From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com] Sent: Wednesday, May 03, 2006 10:15 AM
To: Cary Millsap
Cc: oracle-l_at_freelists.org
Subject: Re: *Measuring sql performance (elapsed time and scalability) by number of logical reads

> 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