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

6. Taxonomy

Roger Cornejo1 
(1)
Durham, NC, USA
 

Feature selection, which was discussed in the last chapter, is a powerful component of the DOPA process. It enables the tuning analyst to quickly identify areas of the database that are performing outside of normal. The metrics with a high incidence of flagged values are assumed to have a high predictive value of pointing to the problem area. And this is definitely true in my experience. While the feature selection/flagging process is sufficient by itself to solve many problems, I learned another analytics “trick” from my son that enabled me to take my analysis one step further. The concept ...

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.