Oracle 12c Performance Tuning: Metrics and Monitoring


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


Overview/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).

Target Audience
Database Administrators, Application Developers, Technical Consultants

Prerequisites
None

Expected Duration (hours)
0.9

Lesson Objectives

Oracle 12c Performance Tuning: Metrics and Monitoring

  • 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
  • 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
  • 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
  • use EM cloud control to create baselines and configure alert thresholds upon them

    • Course Number:
    od_pmte_a03_it_enus

    Expertise Level
    Intermediate