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@xxxxxxxxx] 
Sent: Wednesday, May 03, 2006 10:15 AM
To: Cary Millsap
Cc: oracle-l@xxxxxxxxxxxxx
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


Other related posts: