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