ORACLE REAL APPLICATION CLUSTERS TESTING AND TUNING
Published on 16. February 2012
Book
Paperback/Softback
464 pages
978-0-07-154765-9 (ISBN)
Description
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 scenariosContains real-world examples and illustrationsOutlines an effective analysis and approach to tuning the databaseProvides 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
Includes practical, step-by-step scenariosContains real-world examples and illustrationsOutlines an effective analysis and approach to tuning the databaseProvides 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
More details
Language
English
Place of publication
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
50 Illustrations
ISBN-13
978-0-07-154765-9 (9780071547659)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
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.
Content
Part I:Testing
Chapter 1: Methodology
Chapter 2: Capacity Planning
Chapter 3: Testing for Availability
Chapter 4: Testing for Scalability
Chapter 5: Real Application Testing
Part II: Tuning
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 Storage Subsystem
Chapter 13: Tuning Global Cache
Part III: Tuning the Cluster
Chapter 14: Tuning the Cluster Interconnect
Chapter 15: Optimizing of Distributed Workload
Chapter 16: Tuning the Oracle Clusterware
Chapter 17: Enqueues, Waits, and Latches
Chapter 18: Tuning Third Party Applications for RAC
Chapter 19: Problem Diagnostics
Appendices
Appendix A: Book References
Appendix B: SQL Scripts - Quick Reference
Appendix C: How to Install and Configure OEM on RAC
Chapter 1: Methodology
Chapter 2: Capacity Planning
Chapter 3: Testing for Availability
Chapter 4: Testing for Scalability
Chapter 5: Real Application Testing
Part II: Tuning
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 Storage Subsystem
Chapter 13: Tuning Global Cache
Part III: Tuning the Cluster
Chapter 14: Tuning the Cluster Interconnect
Chapter 15: Optimizing of Distributed Workload
Chapter 16: Tuning the Oracle Clusterware
Chapter 17: Enqueues, Waits, and Latches
Chapter 18: Tuning Third Party Applications for RAC
Chapter 19: Problem Diagnostics
Appendices
Appendix A: Book References
Appendix B: SQL Scripts - Quick Reference
Appendix C: How to Install and Configure OEM on RAC