Dynamic Oracle Performance Analytics
Using Normalized Metrics to Improve Database Speed
|Price||$25.85 - $32.99
|Format||Paper book / ebook (PDF)|
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.
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
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: $49.08 | Publisher: Apress | Release: 2014
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
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
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
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
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
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