Dynamic Oracle Performance Analytics

Presents an innovative approach to analyzing and improving Oracle Database performance that relies on big data and advanced analytical techniques. The approach in this book is a step-change away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or alternatively having to wade through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, the performance tuner using this book's method is able to draw on all available data, applying big data methods and analytical techniques to draw impactful, focused performance improvement conclusions.
An important part of any performance improvement effort is to pinpoint the problems affecting the database performance that you are working to improve! Once pinpointed, those specific problems can then be addressed. This book reviews past and present practices, along with tools that are used, to pinpoint target areas for improvement. The book then guides you through a step-by-step method that can be used to take advantage of all available metrics to pinpoint problem areas and work toward improving them. This method presented in the book simplifies the tuning process and solves the problem of metric overload for the tuning professional.
Specifically, this book shows how to collect and normalize data, and then generate deltas that are useful in performing statistical analysis. The book shows how to create and use a taxonomy to enhance your understanding of problem performance areas in your database and its applications. All this leads to creating a root cause analysis report that enables understanding of a specific performance problem and its likely solutions.
What You Will Learn
Collect and prepare metrics for analysis from a wide array of sources Apply statistical techniques to select relevant metrics Create a relevant taxonomy to provide additional insight into problem areas Provide a metrics-based root cause analysis regarding the performance issue Generate an actionable tuning plan prioritized according to problem area Monitor performance using database-specific normal ranges

Who This Book Is For
Dynamic Oracle Performance Analytics is for the professional tuner responsible for maintaining the efficient operation of large scale databases who desires to be targeted in his analysis. It is for the tuner who wants to expand his repertoire to include big-data methodology that will enable him/her to use the vast number of metrics available to him without being overwhelmed. It is for the tuner who desires to provide accurate root cause analysis thereby avoiding the cyclical fix-test cycles that are inevitable when speculation is used. The book shows the use of metrics-based analysis to discover performance problems, and the process presented in this book can be combined with machine learning methods to enable more advanced feature selection.