Search Results prvt_sqlpa




Overview
Explore in AI Chat

Overview

SYS.PRVT_SQLPA is a private PL/SQL package owned by the SYS schema and shipped as part of the Oracle Database kernel, including the versions bundled with Oracle E-Business Suite Release 12.1.1 and 12.2.2. The name follows Oracle's internal naming convention, where the PRVT_ prefix designates a private implementation package whose contents are not part of the published API. In this case, PRVT_SQLPA provides the internal implementation layer for the SQL Performance Analyzer (SQLPA) feature delivered through the SQL Tuning Advisor and SQL Tuning Set infrastructure. It is the engine that supports the comparison of SQL workload performance before and after a change, such as a database upgrade, parameter modification, or optimizer statistics refresh.

Within the E-Business Suite context, the package is not an Applications product object. It is a database component that EBS relies on indirectly through the Automatic Workload Repository and SQL Tuning Advisor functionality used by database administrators to validate the impact of changes on the EBS workload.

Key Procedures and Functions

The ETRM metadata for SYS.PRVT_SQLPA documents the package as VALID but records no publicly documented procedures or functions, and the API is classified as OTHER. This is consistent with a private implementation package: its entry points are consumed exclusively by other SYS packages rather than exposed to callers directly. The documented dependency metadata confirms that DBMS_SQLTUNE and DBMS_SQLTUNE_INTERNAL both reference PRVT_SQLPA, establishing it as the lower-level implementation used by those public APIs to build and execute SQL performance analysis tasks. Functionality is therefore invoked through the public SQL Tuning Advisor interface rather than by name.

Tables Accessed

The documented table reference indicates access to XMLAGG. In practice, this reflects that PRVT_SQLPA assembles XML fragments representing SQL statements, execution plans, and comparison results during performance analysis. These fragments are generated internally and returned to the calling DBMS_SQLTUNE routines or stored in SQL Performance Analyzer repository structures. The package does not read or write EBS application tables through APPS synonyms; its data interactions are confined to the database's own tuning and diagnostic repository.

Usage Notes

SYS.PRVT_SQLPA is not invoked directly from E-Business Suite forms, concurrent programs, or custom application code. It is reached when a DBA or an automated process calls the publicly documented SQL Performance Analyzer APIs, typically DBMS_SQLPA within the database toolset. The ETRM metadata records that the package is referenced by three other packages, confirming that it sits beneath DBMS_SQLTUNE, DBMS_SQLTUNE_INTERNAL, and itself as part of a layered implementation. Administrators performing upgrade validation, regression testing of SQL workload after patching, or optimizer change assessment trigger this code path through those higher-level entry points. Because the package is owned by SYS and marked private, direct invocation is unsupported, and any custom code should use DBMS_SQLTUNE or the SQL Performance Analyzer API surface instead.