© 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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.