Performance Tuning uses diagnostic tools to gather statistics, statistic rates, and sampled statistics in order to tune the database system to provide the best performance as efficiently as possible. Although there are specific tuning areas for Oracle Database 11g: RAC, such as instance recovery and interconnect traffic, you will get the best performance by tuning your RAC system the same as you would with a single-instance system. The same tuning tools are available for RAC as would be for a single-instance system. This course explains instance recovery in RAC, describes RAC wait events and latencies, and provides the most common RAC tips for tuning performance in a RAC environment. It also discusses how to monitor and diagnose RAC performance using Enterprise Manager and Automatic Database Diagnostic Monitor (ADDM). In addition, it demonstrates in detail how to use the Cluster Database Performance pages to monitor RAC database and cluster performance.
0 reviews
Provider:
Training Location:
Price:
Duration:
Certificate: