Dynamic Oracle Performance Analytics

Using Normalized Metrics to Improve Database Speed

Authors: Cornejo, Roger

Download source code Free Preview
  • Presents a dynamic process that overcomes limitations of older tuning approaches
  • The process in this book does not rely on AWR, and can be applied in any database
  • The method draws from big data techniques to massively scale across thousands of available metrics
see more benefits

Buy this book

eBook $24.99
price for USA (gross)
  • ISBN 978-1-4842-4137-0
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $32.99
price for USA
  • ISBN 978-1-4842-4136-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

Use an innovative approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach used in this book represents a step-change paradigm shift away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you will draw on all available data, applying big data methods and analytical techniques to help the performance tuner draw impactful, focused performance improvement conclusions. 

This book briefly reviews past and present practices, along with available tools, to help you recognize areas where improvements can be made. The book then guides you through a step-by-step method that can be used to take advantage of all available metrics to identify problem areas and work toward improving them. The method presented simplifies the tuning process and solves the problem of metric overload.
You will learn how to: collect and normalize data, generate deltas that are useful in performing statistical analysis, create and use a taxonomy to enhance your understanding of problem performance areas in your database and its applications, and create a root cause analysis report that enables understanding of a specific performance problem and its likely solutions. 

What You'll Learn

  • Collect and prepare metrics for analysis from a wide array of sources
  • Apply statistical techniques to select relevant metrics  
  • Create a 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 areas
  • Monitor performance using database-specific normal ranges

Who This Book Is For
Professional tuners: responsible for maintaining the efficient operation of large-scale databases who wish to focus on analysis, who want to expand their repertoire to include a big data methodology and use metrics without being overwhelmed, who desire to provide accurate root cause analysis and avoid the cyclical fix-test cycles that are inevitable when speculation is used

About the authors

​Roger Cornejo has been an Oracle enthusiast since 1985 (versions 4-12c). He has experience on large enterprise-class Oracle applications, not only in performance troubleshooting and tuning, but also in systems architecture, information modeling, and software development/project management. For the past 10 years, his main focus has been database performance analysis and tuning, with much of his time spent exploring the complexities and usefulness of AWR* tuning data. He produces Oracle Database tuning results across 12c/11g/10g (and occasionally 9i) databases. He is a thought-leader in his field, and has been recognized for his expertise in tuning. He has presented at the past eight East Coast Oracle Conferences, as well as at COLLABORATE14 and COLLABORATE18, RMOUG16, and Hotsos 2017-2018.  

Table of contents (10 chapters)

Table of contents (10 chapters)
  • Performance Tuning Basics

    Pages 3-16

    Cornejo, Roger

  • Gathering Problem Information

    Pages 19-32

    Cornejo, Roger

  • Data Preparation

    Pages 33-59

    Cornejo, Roger

  • Statistical Analysis

    Pages 61-77

    Cornejo, Roger

  • Feature Selection

    Pages 79-89

    Cornejo, Roger

Buy this book

eBook $24.99
price for USA (gross)
  • ISBN 978-1-4842-4137-0
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $32.99
price for USA
  • ISBN 978-1-4842-4136-3
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Dynamic Oracle Performance Analytics
Book Subtitle
Using Normalized Metrics to Improve Database Speed
Authors
Copyright
2018
Publisher
Apress
Copyright Holder
Roger Cornejo
eBook ISBN
978-1-4842-4137-0
DOI
10.1007/978-1-4842-4137-0
Softcover ISBN
978-1-4842-4136-3
Edition Number
1
Number of Pages
XXI, 224
Number of Illustrations
83 b/w illustrations
Topics