Course Details

Previous Page


Oracle Database 12c RAC Administration: Monitoring and Tuning


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



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