> Presentations >

  The Average Deception (OTN LAC Tour August 2012 ppt)


Product Code: 201208_AVGDEC

To download click here.

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


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:


view my cart my account my support contact us about us        

                                Built with Volusion                                                                 To receive OraPub's Newsletter »