Oracle | PRVT_SQLADV

Oracle PRVT_SQLADV_INFRA 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 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_SQLDIAG_INTERNAL	DBMS_SQLTUNE_UTIL2	SQLSET_ROW
DBMS_SQLPA	DBMS_STANDARD	SQL_BINDS
DBMS_SQLTUNE

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