Search Results prvt_awr_numtab

Overview

SYS.PRVT_AWR_DATA is an Oracle-supplied internal PL/SQL package that forms part of the Automatic Workload Repository (AWR) infrastructure within the Oracle database kernel that underpins Oracle E-Business Suite 12.1.1 and 12.2.2. The PRVT_ prefix indicates that this is a private, wrapped implementation package — it is not part of the public AWR API and is not intended for direct invocation by application code. Its role is to provide the underlying data-manipulation and data-structuring logic used by the AWR reporting and snapshot-management layer, including the population of AWR data tables and the construction of XML-based result sets consumed by higher-level AWR packages. Within an EBS environment, AWR is the performance diagnostic repository used by DBAs to investigate database-tier performance issues affecting the EBS application tier, concurrent managers, and online forms sessions. PRVT_AWR_DATA is therefore a supporting kernel object rather than an EBS application object; it carries no EBS business logic and is not exposed through any EBS form, concurrent program, or public API.

Key Procedures and Functions

The ETRM metadata documents this package as an API classification of OTHER with zero documented procedures or functions. This is consistent with its nature as a private implementation package: its callable units are intentionally undocumented and are subject to change between database releases. No parameter lists, signatures, or individual routine names are published, and none should be inferred or relied upon. What is documented is the package's structural relationship to two other objects. It references SYS.PRVT_AWR_NUMTAB — the numeric table-type helper object that the user's search term "prvt_awr_numtab" targets — and SYS.PRVT_AWR_PERIOD, which supplies period-handling logic for AWR snapshot ranges. It also depends on the XMLTYPE datatype, confirming that PRVT_AWR_DATA constructs or consumes XML documents as part of its processing. The package is additionally self-referential, meaning it contains internal calls between its own routines, and it is referenced by PRVT_CPADDM, the private package handling the Change Point / Automatic Database Diagnostic Monitor detection logic. This dependency chain places PRVT_AWR_DATA firmly inside the ADDM/AWR analytics stack rather than the EBS application stack.

Tables Accessed

The provided metadata does not enumerate base tables accessed via APPS synonyms, which is expected for a SYS-owned kernel package — it operates on database-internal AWR repository objects (the WRH$ and WRI$ family of tables and their public DBA_HIST_ views) rather than on EBS application tables. As a consequence, it appears nowhere in the APPS synonym dependency listings and has no relationship to EBS transactional tables. Its data access is bounded to the AWR schema's own storage and to the transient XMLTYPE structures it builds in memory.

Usage Notes

PRVT_AWR_DATA is never invoked directly by EBS forms, concurrent programs, or customer extension code. It is called implicitly by the database whenever AWR snapshot generation, AWR report rendering, or ADDM analysis runs — most commonly through the DBMS_WORKLOAD_REPOSITORY package, Enterprise Manager performance pages, or the awrrpt.sql / addmrpt.sql scripts. In an EBS 12.1.1 or 12.2.2 environment, these activities are typically scheduled by the DBA using the standard AWR snapshot interval rather than triggered by EBS itself. Because the package is private, wrapped, and release-specific, custom code must not call it, reference its routines, or depend on its internal structures; doing so risks breakage on database patch or upgrade. The correct integration points remain the public DBMS_WORKLOAD_REPOSITORY and DBMS_ADVISOR APIs. Any investigation involving this package should be treated as a database-side performance diagnostic task owned by the DBA team, not as an EBS application customization concern.