Oracle Real Application Clusters

"The latest versions of Oracle®, 9i RAC and 10g, both include important features in the area of performance optimization and high availability. The new features can be daunting if you don"t have experts in house, and having the right roadmap to help you through these new features is critical. This book does an excellent job at recognizing the setup, migration, and performance challenges every company will face, and will help your company optimize instance efficiency in your production database environment. Whether you are planning a move to Oracle® 9i RAC, Oracle 10g, or just want to get the most out of your base Oracle® system, I highly recommend this book."Jeff Carter, Chief Technology Officer, Elogex, Inc. For the first time, Murali Vallath dissects the mysteries of Real Application Clusters (RAC) in his book Oracle Real Application Clusters to enlighten and educate you on the internals of RAC operations, cache fusion, fusion recovery processes, and the fast reconfiguration of RAC. Oracle Real Application Clusters takes you through a logical flow from RAC concepts to operations, covering each facet with a fine-tooth comb. New and experienced users of RAC, as well as those seeking to expand their knowledge of this dynamic technology, will find this book to be a necessity for both home and office reference libraries. Vallath provides comprehensive coverage of the features, technology, and principles of RAC that is part of the Oracle9i, 9iR2 and 10G release of Oracle's RDBMS product. It is divided into three main parts: application/database design, development, and maintenance life cycles. Compared to its predecessor OPS, the architecture behind RAC implementation has changed significantly. Vallath discusses the various features in a RAC implementation with respect to usage and design considerations, as well as those parameters that are and are not applicable. Areas covered include partitioning, indexes, tablespace management, transaction management, backup, and recovery principles. Performance tuning with examples, troubleshooting, and problem solving scenarios are covered in detail, as well as discussions on the migration process from a single instance database to RAC and migration from an OPS implementation to RAC. Scripts included in this book can be downloaded at www.summersky.biz. Features coverage of: · Administration including trouble shooting of RAC · Configuration of Transparent Application Failover (TAF), using JDBC thick and thin clients · Configuration of Oracle Net Services etc. · Tools used for tuning a RAC configuration · Oracle"s wait interface, including waits specific to a RAC instance and its practical application. · Using Oracle"s event interface to tune complex SQL queries · Extensive coverage of usage, day-to-day functions and operations · Tips and techniques such as script samples to illustrate various features of RAC · Comparisons with Oracle parallel server · Discussions on implementing RAC on various operating systems · Analyzing using Oracle dumps · Functions of GCS and GES services with respect to transaction management and transaction recovery · Internals of RAC architecture Murali Vallath has over 17 years of information technology experience. He specializes in implementation, configuration and performance tuning of Oracle parallel server/Oracle real application clusters. He has numerous RAC implementations to his credit. He is a regular contributor to the Oracle-L list server and is a regular speaker at various national and international conferences on Oracle parallel server/Oracle real application cluster and performance tuning topics. Vallath can be reached at murali.vallath@summersky.biz or muralivallath@hotmail.com. Books.Elsevier.com/digitalpress/Vallath, Murali is the author of 'Oracle Real Application Clusters' with ISBN 9781555582883 and ISBN 1555582885.