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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SQLPA
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx