Search Results dbms_management_packs




Overview
Explore in AI Chat

Overview

SYS.DBMS_MANAGEMENT_PACKS is a server-side PL/SQL package owned by the SYS schema and shipped as a VALID object in Oracle Database and Oracle E-Business Suite environments, including EBS 12.1.1 and 12.2.2. Its principal role is license administration for the Oracle Database Management Pack options — the separately licensed Enterprise Manager and Diagnostics/Tuning Pack features built on the Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), SQL Tuning Advisor, SQL Access Advisor, and related instrumentation. In an EBS context, this package governs whether those diagnostic repositories are enabled, how their data is configured and purged, and whether the control infrastructure reports the pack as licensed and available.

The package is classified in ETRM as an OTHER API, indicating it is not a published EBS business API, but rather a database-level utility surfaced through the SYS schema and invoked by internal advisories and infrastructure components. Because it controls high-volume repository features that can consume significant space, its enablement state directly affects the size and maintenance profile of the AWR and ADDM schemas that exist alongside most EBS 12.x databases.

Key Procedures and Functions

Five documented entry points are published for this package:

  • CHECK_PACK_ENABLED — Reports whether a given Management Pack option is enabled or disabled in the current database, allowing callers and inventory tools to verify licensed status before invoking dependent diagnostics.
  • MODIFY_AWR_SETTINGS — Adjusts the configuration parameters that govern AWR data retention and collection behaviour, such as retention and interval settings used by the repository.
  • PURGE — Removes repository content governed by Management Pack functionality, providing the standard mechanism to release space consumed by diagnostic data.
  • PURGE_AWR — Performs a targeted purge of AWR snapshot data specifically, complementing the broader PURGE routine.
  • REPORT — Produces the definitive report of currently enabled and disabled Management Pack options for the database instance.

Parameter lists are intentionally not documented here; callers should use the live package specification or the Data Dictionary views as the authoritative signature reference.

Tables Accessed

The ETRM metadata for this object does not enumerate fixed relational tables reached through APPS synonyms. Consistent with its function, the package operates on the dictionary and fixed views that expose Management Pack state, AWR snapshot history, and repository statistics rather than on EBS application tables. Retention and purge operations act against the AWR snapshot and baseline repositories, while report and check routines read the dictionary flags that record licensed feature state.

Usage Notes

DBMS_MANAGEMENT_PACKS is referenced by thirteen dependent packages, chiefly database-level advisories and infrastructure utilities such as DBMS_ADDM, DBMS_ADVISOR, DBMS_SQLTUNE, DBMS_SQLDIAG, DBMS_PERF, DBMS_ASH_INTERNAL, DBMS_WORKLOAD_REPLAY, PRVT_ADVISOR, and PRVT_AWR_VIEWER. It is therefore invoked indirectly whenever those advisories need to confirm licensing or manage repository settings. Direct invocation in EBS is uncommon and typically limited to DBA scripts, space management routines, and custom purge jobs. Because Management Pack options are licensed features, administrators should confirm entitlement before enabling or purging their repositories, and should avoid running purge operations during peak processing windows as they can be resource intensive.