Search Results dbms_wrr_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_WRR_INTERNAL is an Oracle Database-supplied PL/SQL package that forms part of the internal infrastructure supporting the Workload Repository and Workload Replay tooling. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package is not an Applications-owned object; it resides in the SYS schema and is shipped as part of the standard database kernel. Its role is to provide private, internal services consumed by the higher-level Workload Replay and Workload Capture packages, which are themselves used to record, persist, and subsequently replay representative database workload for performance testing, tuning, and capacity validation.

The object is documented as VALID, confirming that the package and its body compiled successfully and are present in a deployable state. Because the ETRM record exposes the object primarily as a metadata dependency node, its business function is best understood through its dependency graph rather than through an extensive public API.

Key Procedures and Functions

The ETRM metadata documents zero procedures or functions for this package. DBMS_WRR_INTERNAL is an undocumented, Oracle-proprietary internal package; its callable units are not exposed or supported as a public interface and are therefore not enumerated in the reference documentation. No parameter lists can be published. Practically, the package exposes internal helpers that marshal workload replay data, manage XML-based payload structures, and coordinate between the workload capture and replay frameworks. Consumers should treat all members as private implementation detail.

Tables Accessed

The documented table access for DBMS_WRR_INTERNAL occurs through the APPS synonym XMLAGG. XMLAGG is the SQL/XML aggregate function used to concatenate XML fragments into a single XMLType document. Within the Workload Replay architecture, workload streams and replay metadata are represented as XML payloads, and XMLAGG provides the aggregation capability needed to assemble multi-row workload records into consolidated XML documents. The dependency listing further confirms the package's reliance on SYS.XMLTYPE, which is the datatype used to hold these aggregated documents. The package operates on structured workload data rather than on E-Business Suite application tables, and no APPS-owned business tables are documented as accessed by it.

Usage Notes

DBMS_WRR_INTERNAL is never invoked directly from E-Business Suite forms, concurrent programs, or supported customization code. It is called exclusively by the Oracle Database workload replay stack. The dependency metadata shows that it is referenced by DBMS_RAT_MASK, DBMS_WORKLOAD_CAPTURE, DBMS_WORKLOAD_REPLAY, and recursively by itself. DBMS_WORKLOAD_CAPTURE and DBMS_WORKLOAD_REPLAY are the documented entry points used by DBAs to capture and replay workload in support of Database Replay, a standard Oracle performance engineering technique.

  • Invocation context: internal, called by database Workload Capture, Workload Replay, and RAT masking packages — not from EBS application code.
  • Supported surface: customers and EBS implementers should use DBMS_WORKLOAD_CAPTURE and DBMS_WORKLOAD_REPLAY, not DBMS_WRR_INTERNAL.
  • Dependency caution: because the package is proprietary and undocumented, its internal signatures may change across database patch levels and EBS release bundles; custom code must not reference it.
  • Upgrade relevance: the package is refreshed as part of database upgrades and patch set updates applied beneath the EBS 12.1.1 or 12.2.2 technology stack.

In summary, DBMS_WRR_INTERNAL is a private SYS-owned supporting package for Oracle Database Workload Replay, present and valid in EBS 12.1.1 and 12.2.2, whose role is to service the workload capture and replay framework rather than to deliver any application-level business function.