Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services






Metrics, alerts, baselines, and thresholds are monitoring objects that can be used to monitor and manage the performance tuning of an Oracle Database 11g environment. Automatic Workload Repository (AWR) based tools can be used to tune automatic maintenance tasks and generate and read ADDM and ASH reports. This course demonstrates how to create static and repeating baselines, compute baseline statistics, define alert thresholds, and generate ADDM and ASH reports. In Oracle Database 11g you can configure, manage, and implement services to work with client applications using Database Resource Manager and the Scheduler. This course discusses the use of services for monitoring applications and demonstrates how to set performance-metric thresholds on services. It also explains how to configure services aggregation and tracing.


A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.


2.5

Metrics, Alerts, Baselines, and Thresholds

  • identify the features of metrics, alerts, and baselines
  • recognize how to view metric history information, metric details, and histogram views
  • recognize how to receive an alert when a specified threshold is exceeded
  • identify the features of AWR baselines
  • recognize how to create AWR baselines
  • recognize how to manage AWR baselines
  • recognize how to manage thresholds
  • Using AWR-Based Tools

  • recognize how to tune automatic maintenance tasks
  • recognize how to generate and read ADDM reports
  • identify the features of the Active Session History
  • recognize how to generate ASH reports
  • Configuring, Managing, and Implementing Services

  • recognize how to configure and manage services
  • recognize how to use services with client applications, the Database Resource Manager, and the Scheduler
  • recognize how to set performance-metric thresholds on services
  • recognize how to configure services aggregation and tracing

  • od_odpt_a03_it_enus