Dynamic Oracle Performance Analytics

Using Normalized Metrics to Improve Database Speed



Bookstore > Books > Dynamic Oracle Performance Analytics

Price$25.85 - $32.99
Rating
AuthorRoger Cornejo
PublisherApress
Published2018
Pages224
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484241363
ISBN-139781484241363
EBook Hardcover Paperback

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.

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.




Similar Books


Optimizing Oracle Performance

Optimizing Oracle Performance

by Cary Millsap, Jeff Holt

Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In Optimizing Oracle Performance, Cary Millsap, former VP of Oracle's System Performance Group...

Price:  $4.18  |  Publisher:  O'Reilly Media  |  Release:  2003

Troubleshooting Oracle Performance, 2nd Edition

Troubleshooting Oracle Performance, 2nd Edition

by Christian Antognini

Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the most well-respected books in its field. T...

Price:  $52.66  |  Publisher:  Apress  |  Release:  2014

Oracle Performance Tuning, 2nd Edition

Oracle Performance Tuning, 2nd Edition

by Mark Gurry, Peter Corrigan

The first edition of this book became a classic for developers and DBAs. This edition offers 400 pages of updated material on Oracle features, including parallel server, parallel query, Oracle Performance Pack, disk striping and mirroring, RAID, MPPs, SMPs, distributed databases, backup and recovery, and much more....

Price:  $5.72  |  Publisher:  O'Reilly Media  |  Release:  1996

Oracle Database Performance and Scalability

Oracle Database Performance and Scalability

by Henry H. Liu

With database concepts and theories clearly explained in Oracle's context, readers quickly learn how to fully leverage Oracle's performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author's more than ten years of experience worki...

Price:  $87.99  |  Publisher:  Wiley  |  Release:  2011

Oracle Database 12c Performance Tuning Recipes

Oracle Database 12c Performance Tuning Recipes

by Sam Alapati, Darl Kuhn, Bill Padfield

Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to le...

Price:  $46.46  |  Publisher:  Apress  |  Release:  2013

Oracle Database 11gR2 Performance Tuning Cookbook

Oracle Database 11gR2 Performance Tuning Cookbook

by Ciro Fiorillo

Oracle's Database offers great performance, scalability, and many features for DBAs and developers. Due to a wide choice of technologies, successful applications are good candidates to run into performance issues and when a problem arises it's very difficult to identify the cause and the right solution to the problem.The Oracle ...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2012

Social Media Analytics Strategy

Social Media Analytics Strategy

by Alex Goncalves

This book shows you how to use social media analytics to optimize your business performance. The tools discussed will prepare you to create and implement an effective digital marketing strategy. From understanding the data and its sources to detailed metrics, dashboards, and reports, this book is a robust tool for anyone seeking a tangibl...

Price:  $27.04  |  Publisher:  Apress  |  Release:  2017

Dynamic SQL, 2nd Edition

Dynamic SQL, 2nd Edition

by Edward Pollack

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to impro...

Price:  $30.40  |  Publisher:  Apress  |  Release:  2019