Expert Oracle RAC Performance Diagnostics and Tuning | Murali Vallath | ApressIt seems that you're in Germany. We have a dedicated site for Germany. 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.
Original price : Unknown Site price : free. Working for several years across several industries on various RAC projects, there have been several occasions to troubleshoot performance issues in a production environment. Applications and databases that where moved from a single-instance Oracle environment to a two or more node RAC environment to hide a performance problem. This really does not happen this way; RAC cannot do magic to fix poorly written structured query language SQL statements or SQL statements that have not been optimized. Moving to a RAC environment for the right reasons namely, availability and scalability should be done only when the application and environments that have been tested and proven to meet the goals. This is either because testing was never considered as part of the project plan or because testing was not completed due to project schedule delays. Testing the application through the various phases discussed in this book helps identify the problem areas of the application; and tuning them helps eliminate the bottlenecks.
About this book
Database Performance Tuning Goals - Oracle Performance Tuning
Navigation menu Library Catalogue. Publication info: Berkeley, CA : Apress, Format: EBook , Book , Online. New Search. Subject: Oracle Computer file. Relational 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.