> Presentations >

  The Average Deception (OTN LAC Tour August 2012 ppt)



 
Free

Product Code: 201208_AVGDEC
To download click here.

Description
 
This presentation was given by Craig Shallahamer at the OTN Latin American Tour in August of 2012 in Sao Paulo, Brazil.

To download the zip file, add this product to your chart and checkout.

The presentation references three free OraPub tools:
- Wait Event Time Distribution Analysis Tool
- SQL Elapsed Time Sampler
- SQL Elapsed Time Collector

Abstract:

The word "average" immediately congers pictures of a nice evenly balanced figure with sometimes the results being higher and sometimes the results being lower. However, in Oracle performance analysis this is rarely the case. This reality mismatch, observing it and using it to our analysis advantage, is what this presentation is all about. Interestingly, experimental and production system evidence shows SQL elapsed times, wait event times, transaction arrival rates, and the time to service a transaction are clearly not normally distributed. By understanding what actually occurs we can communicate more clearly, better set expectations, focus on what is really important, anticipate solution impact, and draw many interesting conclusions. Join us for a surprisingly useful look into deeper Oracle performance analysis.

Share your knowledge of this product with other customers... Be the first to write a review

Browse for more products in the same category as this item:

Presentations

view my cart my account my support

shopping cart powered by Volusion                                                             To receive OraPub activity updates »