© Roger Cornejo 2018
Roger CornejoDynamic Oracle Performance Analyticshttps://doi.org/10.1007/978-1-4842-4137-0_4

4. Statistical Analysis

Roger Cornejo1 
Durham, NC, USA

This chapter addresses the statistical manipulation of the data that has been collected and formatted. I’ll start by reviewing some basic statistical concepts, including normal ranges, outliers, and variance, and then discuss how these concepts are applied as part of the DOPA process to establish normal ranges for the host of metrics that don’t have well-known norms. Don’t worry, you don’t have to break out the statistics books; I will show you how to use the embedded Oracle functions to easily accomplish this statistical analysis.

So far, you have learned how to gather the data, ...

Get Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.