Embedded Files
The Diagnostics Pack is a cost option for Oracle Enterprise Edition. It is often used in conjunction with the Tuning Pack.
Features
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_SETTINGSMetrics
Alerts
ViewsMGMT$ALERT_ANNOTATIONSMGMT$ALERT_CURRENTMGMT$ALERT_HISTORYMGMT$ALERT_NOTIF_LOGAlerts
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
Parameters
CONTROL_MANAGEMENT_PACK_ACCESS
CONTROL_MANAGEMENT_PACK_ACCESS
To use the Diagnostics Pack the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC or DIAGNOSTIC+TUNING.
Page updated
Google Sites
Report abuse