Ensuring that a database is performing at its optimum capacity is crucial for any database administrator. Resolving performance problems using views and diagnostic and tuning tools when a database is not meeting its performance requirements is just as important. This course provides key RAC monitoring and tuning techniques using Enterprise Manager Cloud Control and built-in database tools like AWR, ASH, and ADDM. This course is one of a series in the Skillsoft learning path that cover a portion of the objectives for exam 1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure.
Learning Objectives
RAC Database Monitoring and Tuning
- start the course
- describe the approach when tuning a RAC database
- describe the impact of accessing blocks in the global cache and maintaining cache coherency
- describe the importance of using wait events to diagnose performance problems and list some of the important wait event views
- describe the main global cache wait events for current and consistent read blocks
- describe the most frequent enqueue waits and how global enqueue wait events can impact an Oracle RAC database
- list some of the most common tuning techniques that are particularly important for RAC
- describe reasons for index block contention and list ways to mitigate the problem
- describe the impact of frequently allocating space to a segment in RAC
- describe tuning considerations relating to undo blocks, and serialized cross-instance calls
Monitoring with Enterprise Manager
- use Enterprise Manager to get an overview of the performance statistics for the database
- use the Enterprise Manager Cluster Database Performance Page to view problems inside and outside the database
- use the Enterprise Manager Cluster Database Performance Page to view database throughput and drill down to view throughput for specific instances
- use the Oracle Enterprise Manager cloud control cluster cache coherency page to view statistics relating to global cache throughput
- use additional monitoring links in Enterprise Manager to view database locks and to access the top activity page for the database
- use EM Database Express Performance Hub to view both historical and real-time performance data
Built In Database Tuning Tools
- describe how AWR manages snapshots in RAC
- identify RAC-specific sections in an AWR report
- diagnose performance problems with the RAC-specific sections of the Active Session History Report
- use the Automatic Database Diagnostic Monitor to analyze performance for the entire cluster or for individual instances
- list what ADDM diagnoses for RAC and use ADDM-specific pages in Enterprise Manager to diagnose RAC database performance
Practice: Monitoring with Enterprise Manager
- use Enterprise Manager to view database performance and find RAC-specific information in an AWR report