Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Beaking down SQL performance by wait time

Beaking down SQL performance by wait time

From: <fmhabash_at_gmail.com>
Date: Thu, 22 Feb 2007 17:38:21 -0500
Message-ID: <45DE1B5D.3080408@gmail.com> 





In Oracle, you can beak down the performance by wait type. This wait is 
described in terms of count and time and their derivatives. Also, you 
can aggregate these numbers at DB or session level. How do you aggregate 
these number at the SQL hash level at least for the total number of 
executions. I searched in the different views and could not find a way 
on how you do that.


Any ideas will be appreciated.

--
http://www.freelists.org/webpage/oracle-l


Received on Thu Feb 22 2007 - 16:38:21 CST












Original text of this message













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