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 09:52:09 +0200
Message-ID: <008a01c66e86$7c165830$1a03310a@MPILA9>


> Is there a way to get information about how (calls to hash function or
> something else)
> service time (CPU) is used up ?

Responding to my own question:
more information is available in the v$* (I used Tom Kyte's runstats_pkg package, v$mystat/v$latch).

Thank you all for your feedback!

Regards,
Dimitre

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 03 2006 - 02:52:09 CDT

Original text of this message

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