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, cle...

Price:  $4.69  |  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. This s...

Price:  $47.74  |  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:  $50.00  |  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 working with Oracle,...

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

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 Database 1...

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

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

Building Dynamics CRM 2015 Dashboards with Power BI

Building Dynamics CRM 2015 Dashboards with Power BI

by Steve Ivie

Dynamics CRM 2015 holds a wealth of information about customers and the sales pipeline, but sometimes leaves users with basic end-user reporting and dashboard options. Power BI is a great new tool for analyzing and presenting data, giving us the ability to dig deeper into the information. With the increased requests for real-time sales an...

Price:  $35.99  |  Publisher:  Packt Publishing  |  Release:  2015

Oracle Database 12c Release 2 Real Application Clusters Handbook

Oracle Database 12c Release 2 Real Application Clusters Handbook

by K. Gopalakrishnan, Sam R. Alapati

Through clear instruction and detailed examples, Oracle Database 12c Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting teaches how to build, configure, and maintain a dynamic enterprise computing infrastructure. This thoroughly revised edition covers best uses for the latest tools and features - al...

Price:  $40.99  |  Publisher:  McGraw-Hill  |  Release:  2018