Oracle | PRVT_SQLADV

Oracle PRVT_SQLADV_INFRA 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 SQL Advisor Internal Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_ADVISOR	DBMS_SQLTUNE_INTERNAL	DBMS_SYS_ERROR
DBMS_AUTO_SQLTUNE	DBMS_SQLTUNE_UTIL0	DBMS_XPLAN
DBMS_SQLDIAG	DBMS_SQLTUNE_UTIL1	PRVT_ADVISOR
DBMS_SQLPA	DBMS_SQLTUNE_UTIL2	SQLSET_ROW
DBMS_SQLTUNE	DBMS_STANDARD	SQL_BINDS

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvssqlf.plb:

Subprograms

CREATE_TASK

REPORT_AUTO_TUNING_TASK

CREATE_TASK

Undocumented

Overload 1 prvt_sqladv_infra.create_task( advisor_name IN VARCHAR2, sql_text IN CLOB, bind_list IN sys.sql_binds, user_name IN VARCHAR2, scope IN VARCHAR2, time_limit IN NUMBER, task_name IN VARCHAR2, description IN VARCHAR2, con_dbid IN NUMBER, con_id IN NUMBER, task_owner_id IN NUMBER) RETURN VARCHAR2;

TBD

Undocumented

Overload 2 prvt_sqladv_infra.create_task( advisor_name IN VARCHAR2, sql_text IN CLOB, bind_list IN sys.sql_binds, user_name IN VARCHAR2, scope IN VARCHAR2, time_limit IN NUMBER, task_name IN VARCHAR2, description IN VARCHAR2, con_name IN VARCHAR2, task_owner_id IN NUMBER) RETURN VARCHAR2;

TBD

Undocumented

Overload 3 prvt_sqladv_infra.create_task( advisor_name IN VARCHAR2, sql_id IN VARCHAR2, plan_hash_value IN NUMBER, scope IN VARCHAR2, time_limit IN NUMBER, task_name IN VARCHAR2, description IN VARCHAR2, con_name IN VARCHAR2, task_owner_id IN NUMBER) RETURN VARCHAR2;

TBD

Undocumented

Overload 4 prvt_sqladv_infra.create_task( advisor_name IN VARCHAR2, begin_snap IN NUMBER, end_snap IN NUMBER, sql_id IN VARCHAR2, plan_hash_value IN NUMBER, scope IN VARCHAR2, time_limit IN NUMBER, task_name IN VARCHAR2, description IN VARCHAR2, con_name IN VARCHAR2, awr_dbid IN NUMBER, task_owner_id IN NUMBER; RETURN VARCHAR2;

TBD

Undocumented

Overload 5 prvt_sqladv_infra.create_task( advisor_name IN VARCHAR2, sqlset_name IN VARCHAR2, basic_filter IN VARCHAR2, object_filter IN VARCHAR2, rank1 IN VARCHAR2, rank2 IN VARCHAR2, rank3 IN VARCHAR2, result_percentage IN NUMBER, result_limit IN NUMBER, scope IN VARCHAR2, time_limit IN NUMBER, task_name IN VARCHAR2, description IN VARCHAR2, plan_filter IN VARCHAR2, sqlset_owner IN VARCHAR2, task_owner_id IN NUMBER) RETURN VARCHAR2;

TBD

Undocumented

Overload 6 prvt_sqladv_infra.create_task( advisor_name IN VARCHAR2, begin_time IN DATE, end_time IN DATE, basic_filter IN VARCHAR2, rank1 IN VARCHAR2, result_limit IN NUMBER, scope IN VARCHAR2, time_limit IN NUMBER, task_name IN VARCHAR2, description IN VARCHAR2, plan_filter IN VARCHAR2, task_owner_id IN NUMBER) RETURN VARCHAR2;

TBD

Undocumented

Overload 7 prvt_sqladv_infra.create_task( advisor_name IN VARCHAR2, spa_task_name IN VARCHAR2, spa_task_owner IN VARCHAR2, spa_compare_exec IN VARCHAR2, basic_filter IN VARCHAR2, scope IN VARCHAR2, time_limit IN NUMBER, task_name IN VARCHAR2, description IN VARCHAR2, task_owner_id IN NUMBER) RETURN VARCHAR2;

TBD

REPORT_AUTO_TUNING_TASK

Undocumented prvt_sqladv_infra.report_auto_tuning_task( begin_exec IN VARCHAR2, end_exec IN VARCHAR2, type IN VARCHAR2, level IN VARCHAR2, section IN VARCHAR2, object_id IN NUMBER, result_limit IN NUMBER) RETURN CLOB;

TBD