Beaking down SQL performance by wait time
- From: "fmhabash@xxxxxxxxx" <cnewtonne@xxxxxxxxx>
- To: Oracle-L Oracle-L <oracle-l@xxxxxxxxxxxxx>, "fmhabash@xxxxxxxxx" <fmhabash@xxxxxxxxx>
- Date: Thu, 22 Feb 2007 17:38:21 -0500
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