• Online, Self-Paced
Course Description

Metrics are used for system health monitoring, problem detection, and self tuning in Oracle Database 12c. In this course, you will see how performance baselines can be established, so that it is simpler to deduce whether there has been any performance degradation. Finally, real-time database operation monitoring is introduced, which extends and generalizes real-time SQL monitoring. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).

Learning Objectives

Database Metrics and Alerts

  • start the course
  • describe the use of metrics and the importance of statistics within an Oracle database
  • define the Oracle database metrics and describe their benefits
  • use dictionary views and EM cloud control to report on database metrics
  • describe the benefits of having statistics histograms
  • define database alerts and the dictionary views associated with them

Working with Baselines

  • describe how AWR baselines can be used to compare two periods
  • define AWR baselines and its benefits
  • list and describe the types of AWR baselines
  • describe how to create AWR baselines
  • configure AWR baselines and templates
  • describe how baselines are used when defining alert thresholds

Real-time Database Operation Monitoring

  • describe database operations and provide use cases
  • list the scope and concepts around database operations
  • describe how to identify and enable monitoring of a database operation
  • list the steps in identifying, starting, and completing a database operation
  • describe the concept of load database operations and list the dictionary views associated with it
  • describe the PL/SQL package needed to report on database operations

Practice: Using Baselines

  • use EM cloud control to create baselines and configure alert thresholds upon them

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.