The Average Deception (OTN LAC Tour August 2012 ppt)
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
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
To receive OraPub's Newsletter »