-
Book Overview & Buying
-
Table Of Contents
Oracle 11g R1 / R2 Real Application Clusters Handbook
Tuning RAC is based on a complete understanding of Cache Fusion in terms of inter-instance messaging and block transfers. Awareness of the latency statistics, and familiarity with the performance views and AWR to obtain the baseline information for the database behavior, is essential for successful performance tuning. Knowledge of the wait events, associated with RAC, helps in identifying what the processes are waiting for and respectively can point out a solution to reduce the waits leading to performance improvements. Well-known single-instance tuning problems in RAC can exacerbate the performance. Therefore, being well informed in their resolution will help you to improve the RAC performance. In the following sections, we will look at some of the most important factors related to RAC tuning.
Cache Fusion is a new feature of RAC. Reads from disks are involved only if the block is not available in the buffer caches of the...
Change the font size
Change margin width
Change background colour