Book description
"Expert Oracle RAC Performance Diagnostics and Tuning provides comprehensive coverage of the features, technology and principles for testing and tuning RAC databases. The book takes a deep look at optimizing RAC databases by following a methodical approach based on scientific analysis rather than using a speculative approach, twisting and turning knobs and gambling on the system.
The book starts with the basic concepts of tuning methodology, capacity planning, and architecture. Author Murali Vallath then dissects the various tiers of the testing implementation, including the operating system, the network, the application, the storage, the instance, the database, and the grid infrastructure. He also introduces tools for performance optimization and thoroughly covers each aspect of the tuning process, using many real-world examples, analyses, and solutions from the field that provide you with a solid, practical, and replicable approach to tuning a RAC environment. The book concludes with troubleshooting guidance and quick reference of all the scripts used in the book.
Expert Oracle RAC Performance Diagnostics and Tuning covers scenarios and details never discussed before in any other performance tuning books. If you have a RAC database, this book is a requirement. Get your copy today.
Table of contents
- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
-
Chapter 1: Methodology
- Performance Requirements
- Tuning the System
- Methodology
- Oracle Unified Method
-
RAP Testing
- RAP Testing Phase I—Stability Testing of the Cluster
- RAP Testing Phase II—Availability and Load Balancing
- RAP Testing Phase III—High Availability
- RAP Testing Phase IV—Backup and Recovery
- RAP Testing Phase V—Hardware Scalability
- RAP Testing Phase VI—Database Scalability
- RAP Testing Phase VII—Application Scalability
- RAP Testing Phase VIII—Burnout Testing
- Creating an Application Testing Environment
- How Much to Tune?
- Conclusion
- Chapter 2: Capacity Planning and Architecture
- Chapter 3: Testing for Availability
- Chapter 4: Testing for Scalability
- Chapter 5: Real Application Testing
- Chapter 6: Tools and Utilities
- Chapter 7: SQL Tuning
- Chapter 8: Parallel Query Tuning
- Chapter 9: Tuning the Database
- Chapter 10: Tuning Recovery
- Chapter 11: Tuning Oracle Net
- Chapter 12: Tuning the Storage Subsystem
- Chapter 13: Tuning Global Cache
- Chapter 14: Tuning the Cluster Interconnect
- Chapter 15: Optimize Distributed Workload
- Chapter 16: Oracle Clusterware Diagnosis
- Chapter 17: Waits, Enqueues, and Latches
- Chapter 18: Problem Diagnosis
-
Appendix A: The SQL Scripts Used in This Book
- Chapter 3—Testing for Availability
- Chapter 4—Testing for Scalability
- Chapter 5—Real Application Testing
- Chapter 6—Tools and Utilities
- Chapter 9—Tuning the Database
- Chapter 11—Tuning Oracle Net
- Chapter 12—Tuning the Storage Subsystem
- Chapter 13—Tuning Global Cache
- Chapter 14—Tuning the Cluster Interconnect
- Chapter 15—Optimizing Distributed Workload
- Chapter 17—Waits, Enqueues, and Latches
- Chapter 18—Problem Diagnostics
- Bibliography
- Index
Product information
- Title: Expert Oracle RAC Performance Diagnostics and Tuning
- Author(s):
- Release date: October 2014
- Publisher(s): Apress
- ISBN: 9781430267102
You might also like
book
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning
Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how …
book
Pro Oracle Database 11g RAC on Linux
Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters …
book
Oracle 10g RAC Grid, Services & Clustering
Grid architecture is Oracle’s strategy for high-end computing and RAC is the stepping stone into this …
book
Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide
Streamline data management and provisioning Build and manage a storage infrastructure with Oracle scalable Automatic Storage …