Oracle Real Application Clusters Testing and Tuning - 9780071547659

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