Oracle | PRVT

Oracle PRVT_SQLPA Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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_FINDINGS
DBA_ADVISOR_FINDINGS	DBMS_SQLTUNE_UTIL1	WRI$_ADV_OBJECTS
DBA_ADVISOR_OBJECTS	DBMS_STANDARD	WRI$_REPT_SQLPI
DBA_ADVISOR_PARAMETERS	DBMS_SYS_ERROR	WRI$_SQLSET_DEFINITIONS
DBA_ADVISOR_SQLSTATS	DBMS_XPLAN	WRI$_SQLSET_PLANS
DBA_ADVISOR_TASKS	DUAL	WRI$_SQLSET_STATEMENTS
DBA_SQLSET_BINDS	PLITBLM	XMLAGG
DBA_SQLSET_STATEMENTS	PRVTEMX_SQL	XMLSEQUENCE
DBA_SQLTUNE_BINDS	PRVT_ADVISOR	XMLTYPE
DBMS_ASSERT	PRVT_REPORT_TAGS	_ALL_SQLSET_STATISTICS_ONLY
DBMS_AUTO_INDEX_INTERNAL

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

      FROM dual;

      SELECT prvt_sqlpa.i_sts2trial_plan_query_view

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.PRVT_SQLPA", line 3802

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