Oracle Diagnostics Pack

The Diagnostics Pack is a cost option for Oracle Enterprise Edition. It is often used in conjunction with the Tuning Pack.

Features

  • Performance Hub
  • Notifications
  • Metric and Alert/Event History
  • User-Defined Metrics and Metric Extensions
  • Management Connectors
  • Dynamic metric baselines and Adaptive metric thresholds
  • Monitoring templates and Template Collections

ViewsDBA_STREAMS_TP_PATH_BOTTLENECK DBA_STREAMS_TP_COMPONENT_STAT
ViewsMGMT$BLACKOUT_HISTORYMGMT$BLACKOUTS

Metrics

ViewsMGMT$METRIC_COLLECTIONSMGMT$ALERT_CURRENTMGMT$METRIC_DAILYMGMT$METRIC_DETAILSMGMT$METRIC_HOURLYMGMT$TARGET_METRIC_COLLECTIONSMGMT$TARGET_METRIC_SETTINGSMGMT$AVAILABILITY_CURRENTMGMT$AVAILABILITY_HISTORYMGMT$TEMPLATESMGMT$TEMPLATE_METRIC_COLLECTIONMGMT$TEMPLATE_METRIC_SETTINGSMGMT$TEMPLATE_POLICY_SETTINGS

Alerts

ViewsMGMT$ALERT_ANNOTATIONSMGMT$ALERT_CURRENTMGMT$ALERT_HISTORYMGMT$ALERT_NOTIF_LOG
PackagesDBMS_WORKLOAD_REPOSITORYViewsV$ACTIVE_SESSION_HISTORYDBA_HIST_ views (with exceptions)Scriptsawrrpt.sqlawrrpti.sqlawrgrpt.sqlawrgrpti.sqlawrgdrpt.sqlawrgdrpi.sqlashrpt.sqlashrpti.sqlawrddrpt.sqlawrddrpi.sqlawrsqrpi.sqlawrsqrpt.sqlawrextr.sqlawrload.sqlawrinfo.sqlspawrio.sqlspawrrac.sqlFunctionsDBMS_WORKLOAD_REPLAY.COMPARE_PERIOD_REPORT
PackagesDBMS_ADDMDBMS_ADVISOR (with exceptions)ViewsDBA_ADDM_ viewsScriptsaddmrpt.sqladdmrpti.sql

Parameters

CONTROL_MANAGEMENT_PACK_ACCESS

To use the Diagnostics Pack the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC or DIAGNOSTIC+TUNING.