August 2011
Intermediate to advanced
576 pages
16h 12m
English
book
Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition
by K Gopalakrishnan
Content preview from Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...