expert oracle rac 12c,Expert Oracle RAC Performance Diagnostics and Tuning pdf

Expert Oracle RAC Performance Diagnostics and Tuning content validity

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 Catalog

About the Author

About the Technical Reviewer

Acknowledgments

Introduction

Chapter 1: Methodology

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

Bibliography

Index

Expert Oracle RAC Performance Diagnostics and Tuning Wonderful Digest

Irrespective of a new product development effort or an existing product being enhanced to add additional functionality, performance optimization should be considered from the very beginning of a project and should be part of the requirements definition and integrated into each stage of the development life cycle. As modules of code are developed, each unit should be iteratively tested for functionality and performance. Such considerations would make the development life cycle smooth, and performance optimization could follow standards that help consistency of application code and result in improved integration, providing efficiency and performance.