In a Nutshell
Performance tuning in the Oracle RAC environment is similar to tuning in a single-instance environment, with a few additional considerations for Oracle RAC. Applications partitioning and newly introduced performance features such as ASSM also help greatly in Oracle RAC. Caching frequently used sequences and choosing the right block size each has a big positive impact on performance.
New wait events and enhanced statistics-collection tools are available with Oracle Database 11g. Oracle RAC wait events and system statistics provide the fine-grained diagnostic information about the block transfers and interinstance messaging. New optimization techniques and improved statistics-collection metrics at the global cache and enqueue services ...
Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
