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: Please, Which events are usefull in optimizaing out than 10 046 from 10 000 to 20 000

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

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Fri, 1 Oct 2004 12:35:23 -0400
Message-Id: <415D874B.000001.02472@DAZA-MGEJCA5J7T>


Thanks a lot John,

2. Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning, Shee

Is this an specialized book for trace like Millsap's book? Do you know another book specialized in interpreting trace and dump files.

I'm looking for them

Thanks  

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
 

From: Smiley John - IL
Date: 10/01/04 12:32:34
To: 'jreyes_at_dazasoftware.com'; oracle-l_at_freelists.org Subject: RE: Please, Which events are usefull in optimizaing out than 10 046 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:30:53 CDT

Original text of this message

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