RE: Please, Which events are usefull in optimizaing out than 10 0 46 from 10 000 to 20 000

We (hopefully) use extended trace (10046) to generate response time profiles for a focused set of business transactions. The results lead where they lead. We don't set out with any particular list of events in mind. We just look at where the time went and go see if we can find a way to shorten the time without adversely affecting other critical business processes.

There are several excellent books available that will help you make more sense of extended trace data and OWI in particular: 1. Optimizing Oracle Performance, Millsap 2. Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning, Shee

If you need to analyze histograms and how the CBO uses them, take a look at 10053 traces. They provide information about what the CBO is considering in making execution plan choices.

John Smiley

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes Pacheco
Sent: Friday, October 01, 2004 11:19 AM
To: oracle-l_at_freelists.org
Subject: Please, Which events are usefull in optimizaing out than 10 046 from 10 000 to 20 000

Hi, could you please share which events you use to do a deep optimization when generating traces, out than 10046.

For example which event could be useful to analyze histograms.

Thanks in advance.  

Juan Carlos Reyes Pacheco
OCP
--

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

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 01 2004 - 11:27:17 CDT