The Average Deception

• Learn how and why Oracle activity is not what most people think! •

Download Now

The word "average" immediately conjures up pictures of a nice, evenly balanced figure with the results being higher sometimes and lower sometimes. 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 PPT is all about.

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, set better expectations, focus on what is really important, anticipate solution impact, and draw many interesting conclusions.

Search Craig's blog for relevant posts, here.

Related Videos