• Online, Self-Paced
Course 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.

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

 

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.