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

[Smiley John - IL <SMILEYJ@xxxxxxxx>]

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Juan Carlos Reyes Pacheco
Sent: Friday, October 01, 2004 11:19 AM
To: oracle-l@xxxxxxxxxxxxx
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

• Follow-Ups:
  • RE: Please, Which events are usefull in optimizaing out than 10 046 from 10 000 to 20 000
    • From: Juan Carlos Reyes Pacheco

Other related posts:

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

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