Oracle PRVT

Oracle PRVT_SQLPA Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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