Dynamic Oracle Performance Analytics
Using Normalized Metrics to Improve Database Speed
| Price | $25.85 - $32.99
|
| Rating |  |
| Author | Roger Cornejo |
| Publisher | Apress |
| Published | 2018 |
| Pages | 224 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484241363 |
| ISBN-13 | 9781484241363 |
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.
- Roger Cornejo
Similar Books
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 
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
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
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
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
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
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
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