Oracle Database 12c RAC Administration: Monitoring and Tuning Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description
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.
Target Audience
Oracle Database Administrators, Systems Administrators, Technical Consultants.
Prerequisites
None
Expected Duration (hours)
1.6
Lesson Objectives Oracle Database 12c RAC Administration: 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
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
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
use Enterprise Manager to view database performance and find RAC-specific information in an AWR report
Course Number: od_raad_a06_it_enus
Expertise Level
Intermediate