Synopses & Reviews
The Oracle Press guide to tuning Oracle Real Application Clusters (RAC)
Written by an Oracle RAC expert and president of the Oracle RAC Special Interest Group, Oracle Real Application Clusters Testing and Tuning provides comprehensive coverage of the features, technology, and principles of testing and tuning an Oracle RAC database by dissecting the various tiers of its implementation. These include the operating system, network, application, instance, database, and clusterware. This book provides step-by-step advice for removing bottlenecks, minimizing downtime, and increasing overall system performance.
Oracle Real Application Clusters Testing and Tuning
- Includes practical, step-by-step scenarios
- Contains real-world examples and illustrations
- Outlines an effective analysis and approach to tuning the database
- Provides script samples that illustrate various Oracle RAC features
This Oracle Press Guide covers:
Testing Methodology; Testing Hardware for Scalability; Testing Hardware for Availability; Testing Application for Scalability; Tuning Tools and Utilities; Cost Based Optimizer; SQL Tuning; Parallel Query Tuning; Tuning the Database; Tuning Recovery; Tuning Oracle Net; Tuning Storage Subsystem; Block Size Optimization; Tuning the Cluster Interconnect; Tuning the Global Cache Management; Optimization of Distributed Workload; Tuning the Oracle; Clusterware Tuning Third-party Applications for RAC
About the Author
Murali Vallath has more than 18 years of IT experience including more than 13 years using Oracle products. He is an Oracle Certified Professional Database Administrator with expertise in Oracle Real Application Clusters. Vallath is president of the Oracle RAC Special Interest Group, Charlotte Oracle users group, and a contributing editor to the IOUG SELECT journal. He is a regular speaker on Oracle RAC and Oracle RDMS performance and tuning topics at industry conferences, including Oracle OpenWorld, UKOUG, AUSOUG, and IOUG.
Table of Contents
Part I: Testing
; Chapter 1.
Methodology; Chapter 2.
Testing Hardware for Scalability; Chapter 3.
Testing Hardware for Availability; Chapter 4.
Testing Application for Scalability; Part II: Tuning
; Chapter 5.
Tools and Utilities; Chapter 6.
Cost Based Optimizer; 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 Storage Subsystem; Chapter 13.
Block Size Optimization; Part III: Tuning the Cluster
; Chapter 14.
Tuning the Cluster Interconnect; Chapter 15.
Tuning the Global Cache Management; Chapter 16.
Optimization of Distributed Workload; Chapter 17.
Tuning the Oracle; Clusterware Chapter 18.
Tuning Third party applications for RAC; Appendix A.