Skip to main content
SpringerLink
Log in
Apress

Expert Oracle RAC Performance Diagnostics and Tuning

  • Book
  • © 2014

Overview

Authors:
  1. Murali Vallath
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Expert Oracle RAC Performance Diagnostics and Tuning provides comprehensive coverage of the features, technology and principles of testing and tuning the RAC database.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (20 chapters)

  1. Front Matter

    Pages i-xxxii
    Download chapter PDF

  2. Methodology

    • Murali Vallath
    Pages 1-19

  3. Capacity Planning and Architecture

    • Murali Vallath
    Pages 21-54

  4. Testing for Availability

    • Murali Vallath
    Pages 55-85

  5. Testing for Scalability

    • Murali Vallath
    Pages 87-110

  6. Real Application Testing

    • Murali Vallath
    Pages 111-143

  7. Tools and Utilities

    • Murali Vallath
    Pages 145-199

  8. SQL Tuning

    • Murali Vallath
    Pages 201-234

  9. Parallel Query Tuning

    • Murali Vallath
    Pages 235-275

  10. Tuning the Database

    • Murali Vallath
    Pages 277-318

  11. Tuning Recovery

    • Murali Vallath
    Pages 319-337

  12. Tuning Oracle Net

    • Murali Vallath
    Pages 339-353

  13. Tuning the Storage Subsystem

    • Murali Vallath
    Pages 355-385

  14. Tuning Global Cache

    • Murali Vallath
    Pages 387-449

  15. Tuning the Cluster Interconnect

    • Murali Vallath
    Pages 451-493

  16. Optimize Distributed Workload

    • Murali Vallath
    Pages 495-543

  17. Oracle Clusterware Diagnosis

    • Murali Vallath
    Pages 545-583

  18. Waits, Enqueues, and Latches

    • Murali Vallath
    Pages 585-614

  19. Problem Diagnosis

    • Murali Vallath
    Pages 615-652

  20. The SQL Scripts Used in This Book

    • Murali Vallath
    Pages 653-659
Back to top

About this book

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 covers scenarios and details never discussed before in any other performance tuning books. If you have a RAC database, this book is a requirement. Get your copy today.

  • Takes you through optimizing the various tiers of the RAC environment.
  • Provides real life case studies, analysis and solutions from the field.
  • Maps a methodical approach to testing, tuning and diagnosing the cluster

    About the author

    Vallath has more than 26 years of IT experience including over 20 years using Oracle products. Vallath is an Oracle ACE Director and president of All India Oracle Users Group (www.aioug.org). He has worked on a variety of database platforms for small to very large implementations, designing databases for high volume, machine critical, real time OLTP systems. His expertise is with Oracle RAC. Vallath released his second book titled Oracle 10g RAC, Grid, Services and Clustering in March 2006 and has co-authored his third book titled Oracle Automatic Storage Management (ASM) November 2007, from Oracle Press. Vallath currently provides independent consulting services in the areas of capacity planning, high availability solutions and performance tuning of Oracle environments through Summersky Enterprises (www.summersky.biz) with operations in USA and India. He has successfully completed over 100 successful small, medium and terabyte sized RAC implementations for reputed corporate firms. His recent experiences are with archiving historical data for datamarts on Exadata servers. Vallath is a regular speaker at industry conferences, including the Oracle Open World, AIOUG and others on Oracle RAC and Oracle RDBMS Performance and Tuning related topics. Vallath blogs at www.muralivallath.com.

    Bibliographic Information

    Publish with us

    Policies and ethics

    Back to top

    Search

    Navigation