Search Results prvt_hdm




Overview
Explore in AI Chat

Overview

SYS.PRVT_HDM is an Oracle-supplied, internal PL/SQL package that resides in the SYS schema and is shipped as part of the core database technology stack on which Oracle E-Business Suite 12.1.1 and 12.2.2 both depend. The package forms part of the Automatic Database Diagnostic Monitor (ADDM) infrastructure, specifically the subcomponent responsible for rendering Health Monitor and ADDM directive output as structured, reportable content. Its name, PRVT (private) HDM, indicates that it is not a public API; it is an undocumented-in-the-conventional-sense helper package whose routines support higher-level utilities such as DBMS_ADDM and DBMS_MANAGEMENT_PACKS. In the EBS context, PRVT_HDM is visible to the applications stack through the shared Oracle Database installation, and it contributes to the diagnostic and performance-reporting capabilities that administrators use to investigate database health issues affecting the EBS database tier.

Key Procedures and Functions

The ETRM metadata documents PRVT_HDM as a package containing zero explicitly classified procedures or functions under the OTHER API classification. No parameter lists are published for this object, and the documentation does not expose any named entry points. This is consistent with an internal Oracle package that is invoked only by other Oracle-supplied components rather than by customer code. Based on the dependency graph, the package exists to provide helper logic consumed by report-generation routines, particularly those dealing with AWR/ADDM HTML output, as evidenced by its dependency on AWRRPT_HTML_TYPE_TABLE and XMLTYPE. For practical purposes, administrators should treat PRVT_HDM as a black-box supporting module with no supported public interface.

Tables Accessed

The documented dependency list for PRVT_HDM references XMLAGG as the table-level element accessed via APPS synonyms, alongside SQL built-in dependencies such as STANDARD and XMLTYPE. XMLAGG is an aggregate function used to concatenate XML fragments, which strongly supports the package's role in assembling multi-row diagnostic results into a single XML or HTML document. The dependency on AWRRPT_HTML_TYPE_TABLE is a PL/SQL collection type rather than a stored table, further indicating that PRVT_HDM constructs in-memory report structures. The package is referenced by EBS/database objects including DBA_ADDM_SYSTEM_DIRECTIVES, DBA_ADDM_TASK_DIRECTIVES, USER_ADDM_TASK_DIRECTIVES, WRI$_ADV_HDM_T, and WRI$_REPT_ADDM, confirming its integration with the ADDM directive and Advanced Workload Repository reporting structures.

Usage Notes

PRVT_HDM is not intended for direct invocation by EBS forms, concurrent programs, or custom PL/SQL code. It is called exclusively by Oracle-supplied packages, notably DBMS_ADDM, DBMS_MANAGEMENT_PACKS, DBMS_SWRF_REPORT_INTERNAL, and PRVT_AWR_VIEWER. These callers surface output through database diagnostic tooling rather than through EBS application menus. Typical indirect invocation occurs when an administrator generates an ADDM report using DBMS_ADDM, or when the Automatic Workload Repository viewer renders HTML diagnostic pages that include HDM content. Because the package is owned by SYS and classified as OTHER, it is protected by Oracle's internal object conventions; customization, recompilation, or direct calls from the APPS schema are not supported and may invalidate dependent database components. Administrators troubleshooting performance or ADDM-related directives should query the documented referencing views instead of addressing PRVT_HDM directly.