Search Results prvtemx_perf




Overview
Explore in AI Chat

Overview

SYS.PRVTEMX_PERF is a private, internal PL/SQL package owned by the SYS schema and delivered as a standard component of the Oracle E-Business Suite technology stack. The name follows Oracle's established private-package naming convention, in which a PRVT-prefixed package body provides the implementation logic that is exposed publicly through a corresponding interface package. In this case, the public interface is DBMS_PERF, the database package that underpins performance monitoring and diagnostic reporting across the EBS environment. PRVTEMX_PERF therefore functions as a supporting implementation layer rather than as a callable business API.

As a SYS-owned object, the package operates at the database kernel level rather than within the APPS schema. Its role is tightly coupled to performance data collection and the representation of monitoring output, work performed largely behind the scenes on behalf of the DBMS_PERF interface. Because it is not part of the Oracle EBS application object library, it carries no functional or business-rule responsibilities and is never exposed to end users directly.

Key Procedures and Functions

The ETRM metadata documents no public procedures or functions for SYS.PRVTEMX_PERF. This is consistent with its classification as an OTHER-type, private implementation package: the callable surface for performance reporting is published through DBMS_PERF, while PRVTEMX_PERF supplies the underlying routines consumed internally by that package. Consequently, no documented entry points exist that a developer or administrator would invoke by name.

  • Public procedures/functions: none documented (0 total).
  • Internal implementation: logic encapsulated for use by DBMS_PERF.

Because the metadata lists no parameters, no signature details are asserted here; any internal routines should be treated as unsupported and subject to change across releases.

Tables Accessed

The documented metadata records no table references via APPS synonyms for SYS.PRVTEMX_PERF. This is expected given the package resides in SYS and supports database-level performance monitoring rather than application transaction processing. Related repository objects referenced by the metadata include WRI$_REPT_SESSION, a workload repository session object that stores session-level performance reporting data. No direct dependency list links the package to business tables within the APPS schema.

Usage Notes

SYS.PRVTEMX_PERF is invoked indirectly. The documented dependency chain shows it is referenced by DBMS_PERF and by itself (recursive or overloaded internal references), and it in turn references STANDARD and XMLTYPE, reflecting reliance on core PL/SQL built-ins and XML-based data structures.

  • Invocation path: through DBMS_PERF, not by direct application call.
  • Typical consumers: database performance monitoring and diagnostic reporting features.
  • Custom code guidance: do not call this package directly; use DBMS_PERF for any supported interaction.
  • Version scope: applies to Oracle EBS 12.1.1 and 12.2.2, both of which run on the Oracle Database foundation containing this package.

Administrators troubleshooting performance-reporting behavior may encounter SYS.PRVTEMX_PERF in dependency or invalidation reports, but it should be treated as internal Oracle infrastructure and left unmodified.