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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_ADDM
DBMS_SQLDIAG
DBMS_SQLTUNE
DBMS_WORKLOAD_REPOSITORY
PRVT_TUNE_MVIEW
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx