Oracle Real Application Clusters - Softcover

Vallath, Murali

Softcover

ISBN 10: 1555582885 ISBN 13: 9781555582883

Publisher: Digital Press, 2003

Synopsis

Clustered configuration first hit the scene nearly 20 years ago when Digital Equipment Corporation (DEC) introduced the Vax Cluster. Until now, the topic of Real Application Clusters (RAC) implementation had never been fully explored. For the first time, Murali Vallath dissects RAC mysteries in his book Oracle Real Application Clusters to enlighten and educate readers on the internals of RAC operations, cache fusion, fusion recovery processes and the fast reconfiguration of RAC. This book provides comprehensive coverage of the features, technology and principles of RAC that is part of the Oracle9i 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 have changed significantly. Vallath discusses Oracle9i 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, table space 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. Oracle Real Application Clusters takes readers through a logical flow from RAC concepts to operations, covering each facet with a fine-tooth comb. Vallath's skilled writing style makes each chapter entertaining and informative as only a true RAC connoisseur can provide. 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.

About this title

About the Author

About the Author

Murali Vallath has over 18 years of information technology experience and over 13 years using Oracle products. His work spans industries such as broadcasting, manufacturing and telephony and most recently transportation logistics. Vallath is no stranger to the software development life cycle; his solid understanding of IT covers requirement analysis, architecture, modeling, database design, application development, performance tuning and implementation.

Vallath is an Oracle Certified Database Administrator and has worked on a variety of database platforms for small to very large implementations, designing extensive databases for high volume, machine critical, real time OLTP systems. His expertise is with Oracle Real Application Clusters. Vallath has successfully completed over 60 successful small, medium and terabyte sized RAC implementations (Oracle 9i & Oracle 10g) for reputed corporate firms.

Vallath is the president of the RAC SIG (www.oracleracsig.org) and the Charlotte Oracle Users Group (www.cltoug.org).

Vallath is a regular speaker at national and international conferences, including the Oracle Open World, IOUG, UKOUG on RAC and Oracle Performance Tuning related topics.

Vallath currently provides Oracle consulting services through Summersky Enterprises LLC (www.summersky.biz). The firm specializes in implementation and performance tuning of Oracle products, including RAC, Data Guard and Oracle Streams. Prior to this he worked as Senior Database Architect at Elogex Inc. Where apart from the regular performance tuning efforts, he led the Performance Management SWAT team. His previous work and consulting experience includes Hinditron Computers in India, Digital Equipment Corporation, GTE Mobile, Navistar International and DST Interactive (formerly DBS Systems).

Vallath can be reached at murali.vallath@summersky.biz

From the Back Cover

"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/|
"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/

Edition details

• Publisher: Digital Press
• Publication date: 2003
• Language: English
• ISBN 10: 1555582885
• ISBN 13: 9781555582883
• Binding: Paperback
• Number of pages: 804