Search Results prvt_awr_viewer




Overview
Explore in AI Chat

Overview

PRVT_AWR_VIEWER is a privately scoped PL/SQL package owned by the SYS schema in the Oracle E-Business Suite environment. The "PRVT_" prefix denotes that the package is an internal implementation body, not a directly callable public API. Its name associates it with the Automatic Workload Repository (AWR) Viewer facility, the repository-backed framework that collects, stores, and renders database performance data. In EBS 12.1.1 and 12.2.2, AWR-derived metrics underpin several performance and diagnostics features, including the Oracle Diagnostics Pack and the E-Business Suite-specific performance reporting pages, and PRVT_AWR_VIEWER performs the low-level work that these features rely on.

The package encapsulates viewer-side logic: parsing stored AWR snapshots, mapping metadata, and generating XML-based output that is later rendered by the calling applications. The ETRM entry records the object as VALID with an API classification of OTHER, which is consistent with its role as an undocumented internal utility rather than a supported extension point.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents zero public procedures or functions for PRVT_AWR_VIEWER. This is expected: as a PRVT_ package, its callable units are consumed by sibling internal packages rather than exposed to application code. The body appears to concentrate on routines that assemble AWR viewer content, resolve mapping tables, and emit XMLTYPE payloads.

Any specific parameter lists or entry points are intentionally withheld from the documented record.

Tables Accessed

The only table-level reference captured in the documented metadata is XMLAGG, which the ETRM classifier records via APPS synonyms. XMLAGG is an aggregate function used to concatenate XML fragments; its presence confirms that the package builds composite XML documents from AWR data, typically by chaining row-level fragments into a single viewer payload.

Beyond XMLAGG, PRVT_AWR_VIEWER depends on PRVT_AWRV_MAPTAB and PRVT_AWRV_METADATA. PRVT_AWRV_MAPTAB supplies the mapping definitions that align AWR report elements with their source columns, while PRVT_AWRV_METADATA provides the descriptive metadata for those elements. Together these dependencies indicate the package reads definitional data rather than writing to persistent tables.

Usage Notes

PRVT_AWR_VIEWER is referenced by six other packages, notably DBMS_PERF and DBMS_SQLTUNE, as well as PRVTEMX_DBHOME, the EBS Database Home page implementation. This dependency pattern shows the package is invoked indirectly through database performance tooling and through the E-Business Suite performance pages, rather than by forms or concurrent programs directly.

Because the package is owned by SYS and classified as an internal utility under the Oracle Diagnostics Pack, it must not be modified, wrapped, or called from custom code. Any application that requires AWR viewer output should use the supported public APIs (such as DBMS_PERF) or the delivered EBS performance pages. Direct invocation risks invalidating the package and is unsupported by Oracle Support.