Oracle | PRVT

Oracle PRVT_SQLPA Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Internal support for SQL Performance Analyzer

AUTHID CURRENT_USER

Dependencies

ANYDATA	DBMS_REPORT	SYS_IXMLAGG
DBA_ADVISOR_EXECUTIONS	DBMS_SQLTUNE	WRH$_SQLTEXT
DBA_ADVISOR_EXEC_PARAMETERS	DBMS_SQLTUNE_INTERNAL	WRI$_ADV_DEF_PARAMETERS
DBA_ADVISOR_FINDINGS	DBMS_SQLTUNE_UTIL1	WRI$_ADV_EXEC_PARAMETERS
DBA_ADVISOR_OBJECTS	DBMS_STANDARD	WRI$_ADV_FINDINGS
DBA_ADVISOR_PARAMETERS	DBMS_SWAT_MM_INTERNAL	WRI$_ADV_OBJECTS
DBA_ADVISOR_SQLSTATS	DBMS_SYS_ERROR	WRI$_REPT_SQLPI
DBA_ADVISOR_TASKS	DBMS_XPLAN	WRI$_SQLSET_DEFINITIONS
DBA_SQLSET_BINDS	DUAL	WRI$_SQLSET_PLANS
DBA_SQLSET_STATEMENTS	PLITBLM	WRI$_SQLSET_STATEMENTS
DBA_SQLTUNE_BINDS	PRVTEMX_SQL	XMLSEQUENCE
DBMS_ASSERT	PRVT_ADVISOR	XMLTYPE
DBMS_AUTO_INDEX_INTERNAL	PRVT_REPORT_TAGS	_ALL_SQLSET_STATISTICS_ONLY

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvsspai.plb

Subprograms

I_LEVEL_FLAGS_TO_SQL_FLAGS	I_STS_FROM_EXEC	REPORT_SQLPA_TASK
I_STS2TRIAL_PLAN_QUERY_VIEW	REPORT_SPA_TASK_COMPOSITE_XML	REPORT_WORKLOAD_XML

I_LEVEL_FLAGS_TO_SQL_FLAGS

Undocumented prvt_sqlpa.i_level_flags_to_sql_flags( level_flags IN NUMBER, etype IN VARCHAR2) RETURN VARCHAR2;

TDB

I_STS2TRIAL_PLAN_QUERY_VIEW

Undocumented prvt_sqlpa.i_sts2trial_plan_query_view RETURN VARCHAR2;

SELECT prvt_sqlpa.i_sts2trial_plan_query_view;

            
      *

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I_STS_FROM_EXEC

Undocumented prvt_sqlpa.i_sts_from_exec( task_id IN NUMBER, execution_name IN VARCHAR2, execution_type IN VARCHAR2, level_flags IN NUMBER, sqlset_name OUT VARCHAR2, sqlset_owner OUT VARCHAR2);

TDB

REPORT_SPA_TASK_COMPOSITE_XML

Undocumented prvt_sqlpa.report_spa_task_composite_xml( tid IN NUMBER, wkld IN OUT sys.sqltune_util1.task_wkldobj, exec_name IN VARCHAR2, exec_type IN VARCHAR2, exec_id IN NUMBER, obj_id IN NUMBER, result_limit IN NUMBER, level_flags IN NUMBER, section IN VARCHAR2, report_ref IN VARCHAR2, type IN VARCHAR2, error_code IN VARCHAR2) RETURN XMLTYPE;

TDB

REPORT_SQLPA_TASK

Undocumented prvt_sqlpa.report_sqlpa_task( tid IN NUMBER, wkld IN OUT sys.sqltune_util1.task_wkldobj, exec_name IN VARCHAR2, exec_type IN VARCHAR2, obj_id IN NUMBER, result_limit IN NUMBER, level_flags IN NUMBER, section IN VARCHAR2, report_ref IN VARCHAR2, type IN VARCHAR2, error_code IN VARCHAR2, user_metric IN VARCHAR2, sql_id IN VARCHAR2) RETURN XMLTYPE;

TDB

REPORT_WORKLOAD_XML

Undocumented prvt_sqlpa.report_workload_xml(tid IN NUMBER) RETURN XMLTYPE;

TBD