Oracle PRVT_ADVISOR
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 Undocumented
AUTHID DEFINER
Dependencies
DBA_ADVISOR_DIR_DEFINITIONS DBMS_STANDARD
DBMS_STATS
WRI$_ADV_DEF_EXEC_TYPES
DBA_ADVISOR_EXECUTIONS DBMS_STATS_ADVISOR WRI$_ADV_DEF_PARAMETERS
DBA_ADVISOR_FINDING_NAMES DBMS_STATS_INTERNAL WRI$_ADV_DIRECTIVE_DEFS
DBA_ADVISOR_OBJECT_TYPES DBMS_SWAT_ARM_INTERNAL WRI$_ADV_DIRECTIVE_INSTANCES
DBA_ADVISOR_TASKS DBMS_SWAT_MM_INTERNAL WRI$_ADV_EXECUTIONS
DBA_IND_STATISTICS DBMS_SWAT_VER_INTERNAL WRI$_ADV_FINDINGS
DBA_TAB_STATISTICS DBMS_SYSTEM WRI$_ADV_HDM_T
DBMS_ADDM DBMS_SYS_ERROR WRI$_ADV_MESSAGE_GROUPS
DBMS_ADVISOR DBMS_XPLAN_INTERNAL WRI$_ADV_OBJECTS
DBMS_ASSERT DUAL WRI$_ADV_PARAMETERS
DBMS_AUTO_INDEX_INTERNAL NLS_SESSION_PARAMETERS WRI$_ADV_RECOMMENDATIONS
DBMS_AUTO_SQLTUNE PLITBLM WRI$_ADV_REC_ACTIONS
DBMS_AUTO_ZONEMAP PRVTEMX_SQL WRI$_ADV_SEQ_EXEC
DBMS_AUTO_ZONEMAP_INTERNAL PRVT_ACCESS_ADVISOR WRI$_ADV_SEQ_MSGGROUP
DBMS_CUBE_ADVISE PRVT_ADVISOR WRI$_ADV_SEQ_TASK
DBMS_KEA_LIB PRVT_EMX WRI$_ADV_SPM_EVOLVE
DBMS_LOB PRVT_HDM WRI$_ADV_SQLACCESS_ADV
DBMS_MANAGEMENT_PACKS PRVT_PARTREC_NOPRIV WRI$_ADV_SQLTUNE
DBMS_SMB_INTERNAL PRVT_SMGUTIL WRI$_ADV_TASKS
DBMS_SPM PRVT_SQLADV_INFRA WRI$_ADV_TUNEMVIEW_ADV
DBMS_SPM_INTERNAL PRVT_SQLPA WRI$_ADV_USAGE
DBMS_SQLDIAG PRVT_TUNE_MVIEW WRI$_REPT_PLAN_DIFF
DBMS_SQLPA PRVT_WORKLOAD WRI$_REPT_SPMEVOLVE
DBMS_SQLTUNE PRVT_WORKLOAD_NOPRIV WRI$_REPT_SQLPI
DBMS_SQLTUNE_INTERNAL USER$ WRI$_REPT_SQLT
DBMS_SQLTUNE_UTIL0 WRI$_ADV_ABSTRACT_T X$KEACMDN
DBMS_SQLTUNE_UTIL1 WRI$_ADV_ACTIONS XMLSEQUENCE
DBMS_SQLTUNE_UTIL2 WRI$_ADV_DEFINITIONS XMLTYPE
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/
{ORACLE_HOME}/rdbms/admin/
Subprograms
ADJUST_STRING GET_DEFAULT_TASK_PARAMETER RECORD_JOURNAL
CANCEL_TASK GET_DIRECTIVE_ID RECOVER_SINGLE_STALE_TASK
CHECK_ADV_ENABLED GET_REC_ATTRIBUTES RECOVER_STALE_TASKS
CHECK_EXECUTION_STATUS GET_TASK_PARAM RESET_TASK
CHECK_EXPIRATION_COMP GET_TASK_REPORT RESTORE_NLS_NUMBER_ENV
CHECK_INITIAL GET_TASK_SCRIPT SETUP_NLS_NUMBER_ENV
CHECK_MODIFY HANDLE_LOCK SETUP_USER_ENVIRONMENT
CHECK_PACK_ENABLED IMPLEMENT_TASK SET_DEFAULT_TASK_PARAMETER 2
CHECK_TASK_ENABLED INIT_TASK_CONTEXT SET_TASK_PARAMETER 2
CHECK_TEMPLATE INSERT_ACTION SIGNAL_INTERRUPT
COMMON_DELETE_TASK INSERT_ADV_DEFINITION TEST_EXECUTE_TASK
COMMON_EXECUTE_TASK INSERT_ADV_DIR_DEF TRACK_REPORT_USAGE
COMMON_RESET_TASK INSERT_DEF_EXECUTION_TYPE UPDATE_ACTION
CREATE_OBJECT INSERT_DEF_PARAMETER UPDATE_DIRECTIVE
CREATE_TASK INSERT_DIRECTIVE UPDATE_OBJECT 2
DELETE_DIRECTIVE INSERT_DIRECTIVE_I UPDATE_REC_ATTRIBUTES
DELETE_EXPIRED_TASKS INSERT_FINDING UPDATE_TASK 2
DELETE_MESSAGE INSERT_MESSAGE UPDATE_TASK_ATTRIBUTES
DELETE_OBJECT INSERT_OBJECT VALIDATE_ADVISOR
DELETE_TASK INSERT_REC_ACT VALIDATE_COMMAND
DELETE_USER_TASKS INTERRUPT_TASK VALIDATE_EXECUTION
EDIT IS_EMPTY VALIDATE_EXECUTION_ID
EVAL_DIRECTIVE IS_KEYWORD VALIDATE_EXECUTION_OBJECT
FETCH_ADVISOR IS_PACK_ENABLED VALIDATE_EXECUTION_ORDER
FINDING_NAME_EXISTS IS_WILDCARD VALIDATE_ITEM_LENGTH
FORMAT_MESSAGE MARK_RECOMMENDATION VALIDATE_NEW_TASK
FORMAT_MESSAGE_GROUP PARSE_NAME VALIDATE_TASK
GATHER_STATISTICS QUICK_TUNE VALIDATE_TASK_ID
GENERATE_UNIQUE_NAME RECORD_ERRORMSG VALIDATE_USERNAME
GET_DB_VERSION    
 
ADJUST_STRING
Undocumented prvt_advisor.adjust_string(
str     IN VARCHAR2,
max_len IN NUMBER)
RETURN VARCHAR2;
TBD
 
CANCEL_TASK
Undocumented prvt_advisor.cancel_task(
task_name     IN VARCHAR2,
task_owner_id IN BINARY_INTEGER);
TBD
 
CHECK_ADV_ENABLED
Undocumented

Overload 1
prvt_advisor.check_adv_enabled(adv_id IN NUMBER);
TBD
Overload 2 prvt_advisor.check_adv_enabled(adv_name IN VARCHAR2);
TBD
 
CHECK_EXECUTION_STATUS
Undocumented prvt_advisor.check_execution_status(
task_name   IN VARCHAR2,
task_id_num IN BINARY_INTEGER,
exec_name   IN VARCHAR2,
allow_error IN BOOLEAN);
TBD
 
CHECK_EXPIRATION_COMP
Undocumented prvt_advisor.check_expiration_comp(
in_current_time       IN DATE,
base_time             IN DATE,
days_to_expire_string IN VARCHAR2)
RETURN NUMBER;
TBD
 
CHECK_INITIAL
Undocumented prvt_advisor.check_initial(
task_name IN VARCHAR2,
task_id   IN BINARY_INTEGER);
TBD
 
CHECK_MODIFY
Undocumented prvt_advisor.check_modify(
task_name IN VARCHAR2,
task_id   IN BINARY_INTEGER);
TBD
 
CHECK_PACK_ENABLED
Undocumented prvt_advisor.check_pack_enabled(pack_name IN VARCHAR2);
exec prvt_advisor.check_pack_enabled('DIAGNOSTIC');

PL/SQL procedure successfully completed.
 
CHECK_TASK_ENABLED
Undocumented prvt_advisor.check_task_enabled(
task_name     IN VARCHAR2,
adv_name      IN VARCHAR2,
create_task   IN BOOLEAN,
task_owner_id IN BINARY_INTEGER);
TBD
 
CHECK_TEMPLATE
Undocumented prvt_advisor.check_template(
task_name IN VARCHAR2,
task_id   IN BINARY_INTEGER);
TBD
 
COMMON_DELETE_TASK
Undocumented prvt_advisor.common_delete_task(
task_id_num    IN BINARY_INTEGER,
execution_name IN VARCHAR2,
delete_options IN BINARY_INTEGER);
TBD
 
COMMON_EXECUTE_TASK
Undocumented prvt_advisor.common_execute_task(
task_name IN VARCHAR2,
task_operation   IN BINARY_INTEGER,
execution_type   IN VARCHAR2,
execution_name   IN VARCHAR2,
execution_desc   IN VARCHAR2,
execution_params IN sys.dbms_advisor.arglist,
user_id          IN BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
COMMON_RESET_TASK
Undocumented prvt_advisor.common_reset_task(task_num IN BINARY_INTEGER);
TBD
 
CREATE_OBJECT
Undocumented prvt_advisor.create_object(
task_name     IN  VARCHAR2,
object_type   IN  VARCHAR2,
attr1         IN  VARCHAR2,
attr2         IN  VARCHAR2,
attr3         IN  VARCHAR2,
attr4         IN  CLOB,
attr5         IN  VARCHAR2,
object_id     OUT NUMBER,
attr6         IN  RAW,
attr7         IN  NUMBER,
attr8         IN  NUMBER,
attr9         IN  NUMBER,
attr10        IN  NUMBER,
task_owner_id IN BINARY_INTEGER);
TBD
 
CREATE_TASK
Undocumented

Overload 1
prvt_advisor.create_task(
dvisor_name   IN     VARCHAR2,
task_id          OUT NUMBER,
task_name     IN OUT VARCHAR2,
task_desc     IN     VARCHAR2,
template      IN     VARCHAR2,
is_template   IN     VARCHAR2,
prop          IN     BINARY_INTEGER,
how_created   IN     VARCHAR2,
parent_id     IN     NUMBER,
task_owner_id IN     BINARY_INTEGER);
TBD
Overload 2 prvt_advisor.create_task(
advisor_name  IN VARCHAR2,
task_name     IN VARCHAR2,
task_desc     IN VARCHAR2,
template      IN VARCHAR2,
is_template   IN VARCHAR2,
prop          IN BINARY_INTEGER,
how_created   IN VARCHAR2,
task_owner_id IN BINARY_INTEGER);
TBD
Overload 3 prvt_advisor.create_task(
parent_task_name IN     VARCHAR2,
rec_id           IN     NUMBER,
task_id             OUT NUMBER,
task_name        IN OUT VARCHAR2,
task_desc        IN     VARCHAR2,
template         IN     VARCHAR2,
prop             IN     BINARY_INTEGER);
TBD
 
DELETE_DIRECTIVE
Undocumented prvt_advisor.delete_directive(
directive_id  IN BINARY_INTEGER,
instance_name IN VARCHAR2,
task_name     IN VARCHAR2,
task_owner_id IN BINARY_INTEGER);
TBD
 
DELETE_EXPIRED_TASKS
Undocumented prvt_advisor.delete_expired_tasks;
exec prvt_advisor.delete_expired_tasks;

PL/SQL procedure successfully completed.
 
DELETE_MESSAGE
Undocumented prvt_advisor.delete_message(
task_num IN BINARY_INTEGER,
msg_id   IN BINARY_INTEGER);
TBD
 
DELETE_OBJECT
Undocumented prvt_advisor.delete_object(
task_ctx  IN sys.prvt_advisor.task_ctx_type,
object_id IN NUMBER);
TBD
 
DELETE_TASK
Undocumented prvt_advisor.delete_task(
task_name     IN VARCHAR2,
prop          IN BINARY_INTEGER,
task_owner_id IN BINARY_INTEGER);
TBD
 
DELETE_USER_TASKS
Undocumented prvt_advisor.delete_user_tasks(user_name IN VARCHAR2);
TBD
 
EDIT
Undocumented prvt_advisor.edit(
inbuf IN VARCHAR2,
flags IN BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
EVAL_DIRECTIVE
Undocumented prvt_advisor.eval_directive(
directive_id  IN BINARY_INTEGER,
instance_name IN VARCHAR2,
task_name     IN VARCHAR2,
p1            IN CLOB,
p2            IN CLOB,
task_owner_id IN BINARY_INTEGER)
RETURN CLOB;
TBD
 
FETCH_ADVISOR
Undocumented prvt_advisor.fetch_advisor(task_id IN BINARY_INTEGER) RETURN sys.wri$_adv_abstract_t;
TBD
 
FINDING_NAME_EXISTS
Undocumented prvt_advisor.finding_name_exists(
advisor_name IN VARCHAR2,
finding_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
FORMAT_MESSAGE
Undocumented prvt_advisor.format_message(
inc_header IN BINARY_INTEGER,
code       IN VARCHAR2,
arg1       IN VARCHAR2,
arg2       IN VARCHAR2,
arg3       IN VARCHAR2,
arg4       IN VARCHAR2,
arg5       IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
FORMAT_MESSAGE_GROUP
Undocumented prvt_advisor.format_message_group(
group_id IN BINARY_INTEGER,
msg_type IN BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
GATHER_STATISTICS
Undocumented prvt_advisor.gather_statistics(
object_name_filt1 IN VARCHAR2,
object_name_filt2 IN VARCHAR2,
object_name_filt3 IN VARCHAR2,
stale_only        IN BOOLEAN);
TBD
 
GENERATE_UNIQUE_NAME
Undocumented prvt_advisor.generate_unique_name(
target_type   IN  VARCHAR2,
target_prefix IN  VARCHAR2,
target_id     IN  NUMBER,
target_sub_id IN  NUMBER,
target_owner  IN  NUMBER,
target_prop   IN  NUMBER,
new_name      OUT VARCHAR2)
RETURN BOOLEAN;
TBD
 
GET_DB_VERSION
Undocumented prvt_advisor.get_db_version RETURN BINARY_INTEGER;
SELECT prvt_advisor.get_db_version
FROM dual;

GET_DB_VERSION
--------------
     318767104
 
GET_DEFAULT_TASK_PARAMETER
Undocumented prvt_advisor.get_default_task_parameter(
advisor_name IN VARCHAR2,
parameter    IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_DIRECTIVE_ID
Undocumented prvt_advisor.get_directive_id(
advisor_name   IN VARCHAR2,
directive_name IN VARCHAR2)
RETURN BINARY_INTEGER;
TBD
 
GET_REC_ATTRIBUTES
Undocumented prvt_advisor.get_rec_attributes(
task_name      IN  VARCHAR2,
recom_id       IN  NUMBER,
action_id      IN  NUMBER,
attribute_name IN  VARCHAR2,
value          OUT VARCHAR2,
task_owner_id  IN  NUMBER);
TBD
 
GET_TASK_PARAM
Undocumented prvt_advisor.get_task_param(
task_id    IN BINARY_INTEGER,
param_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_TASK_REPORT
Undocumented prvt_advisor.get_task_report(
task_name      IN VARCHAR2,
type           IN VARCHAR2,
level          IN VARCHAR2,
section        IN VARCHAR2,
task_owner_id  IN NUMBER,
execution_name IN VARCHAR2,
object_id      IN NUMBER)
RETURN CLOB;
TBD
 
GET_TASK_SCRIPT
Undocumented prvt_advisor.get_task_script(
task_name      IN VARCHAR2,
type           IN VARCHAR2,
rec_id         IN NUMBER,
act_id         IN NUMBER,
task_owner_id  IN NUMBER,
execution_name IN VARCHAR2,
object_id      IN NUMBER)
RETURN CLOB;
TBD
 
HANDLE_LOCK
Undocumented prvt_advisor.handle_lock(
task_id     IN BINARY_INTEGER,
lock_option IN BINARY_INTEGER,
timeout     IN BINARY_INTEGER);
TBD
 
IMPLEMENT_TASK
Undocumented prvt_advisor.implement_task(
task_name     IN VARCHAR2,
rec_id        IN NUMBER,
exit_on_error IN BOOLEAN,
task_owner_id IN BINARY_INTEGER);
TBD
 
INIT_TASK_CONTEXT
Undocumented prvt_advisor.init_task_context(task_id IN NUMBER) RETURN sys.prvt_advisor.task_ctx_type;
TBD
 
Undocumented prvt_advisor.insert_action(
task_ctx            IN OUT sys.prvt_advisor.task_ctx_type,
ename               IN     VARCHAR2,
p_obj_id            IN     NUMBER,
p_command           IN     NUMBER,
p_flags             IN     NUMBER,
p_attr1             IN     VARCHAR2,
p_attr2             IN     VARCHAR2,
p_attr3             IN     VARCHAR2,
p_attr4             IN     VARCHAR2,
p_attr5             IN     CLOB,
p_attr6             IN     CLOB,
p_num_attr1         IN     NUMBER,
p_num_attr2         IN     NUMBER,
p_num_attr3         IN     NUMBER,
p_num_attr4         IN     NUMBER,
p_num_attr5         IN     NUMBER,
p_msg_id            IN     NUMBER,
p_filtered          IN     CHAR,
p_res_status#       IN     NUMBER,
p_res_last_modified IN     TIMESTAMP,
p_res_msg_id        IN     NUMBER)
RETURN NUMBER;
TBD
 
INSERT_ADV_DEFINITION
Undocumented prvt_advisor.insert_adv_definition(
l_id   IN NUMBER,
l_name IN VARCHAR2,
l_prop IN NUMBER,
l_type IN sys.wri$_adv_abstract_t);
TBD
 
INSERT_ADV_DIR_DEF
Undocumented prvt_advisor.insert_adv_dir_def(
l_adv_id  IN BINARY_INTEGER,
l_name    IN VARCHAR2,
l_domain  IN VARCHAR2,
l_descrip IN VARCHAR2,
l_type    IN BINARY_INTEGER,
l_flags   IN BINARY_INTEGER);
TBD
 
INSERT_DEF_EXECUTION_TYPE
Undocumented prvt_advisor.insert_def_execution_type(
l_adv_id IN NUMBER,
l_id     IN NUMBER,
l_name   IN VARCHAR2,
l_flags  IN NUMBER,
l_desc   IN VARCHAR2);
TBD
 
INSERT_DEF_PARAMETER
Undocumented prvt_advisor.insert_def_parameter(
l_id        IN NUMBER,
l_name      IN VARCHAR2,
l_dtype     IN NUMBER,
l_value     IN VARCHAR2,
l_flags     IN NUMBER,
l_desc      IN VARCHAR2,
l_exec_type IN VARCHAR2);
TBD
 
INSERT_DIRECTIVE
Undocumented prvt_advisor.insert_directive(
directive_id  IN BINARY_INTEGER,
instance_name IN VARCHAR2,
task_name     IN VARCHAR2,
document      IN CLOB,
task_owner_id IN BINARY_INTEGER);
TBD
 
INSERT_DIRECTIVE_I
Undocumented prvt_advisor.insert_directive_i(
directive_id  IN BINARY_INTEGER,
instance_name IN VARCHAR2,
task_id       IN BINARY_INTEGER,
document      IN CLOB);
TBD
 
INSERT_FINDING
Undocumented

Overload 1
prvt_advisor.insert_finding(
task_id       IN NUMBER,
finding_id    IN NUMBER,
ename         IN VARCHAR2,
ftype         IN NUMBER,
fparent       IN NUMBER,
obj_id        IN NUMBER,
impact        IN NUMBER,
impact_msg_id IN NUMBER,
find_msg_id   IN NUMBER,
info_msg_id   IN NUMBER,
name_msg_code IN VARCHAR2,
flags         IN NUMBER);
TBD
Overload 2 prvt_advisor.insert_finding(
task_ctx      IN OUT sys.prvt_advisor.task_ctx_type,
ename         IN     VARCHAR2,
ftype         IN     NUMBER,
fparent       IN     NUMBER,
obj_id        IN     NUMBER,
impact        IN     NUMBER,
impact_msg_id IN     NUMBER,
find_msg_id   IN     NUMBER,
info_msg_id   IN     NUMBER,
name_msg_code IN     VARCHAR2,
flags         IN     NUMBER);
TBD
 
INSERT_MESSAGE
Undocumented

Overload 1
prvt_advisor.insert_message(
taskid       IN NUMBER,
find_similar IN BOOLEAN,
ename        IN VARCHAR2,
facility     IN VARCHAR2,
msg_num      IN NUMBER,
arg1         IN VARCHAR2,
arg2         IN VARCHAR2,
arg3         IN VARCHAR2,
arg4         IN VARCHAR2,
arg5         IN VARCHAR2,
header       IN NUMBER,
mlm          IN NUMBER,
mnl          IN NUMBER,
mseq         IN NUMBER)
RETURN NUMBER;
TBD
Overload 2 prvt_advisor.insert_message(
task_ctx     IN OUT sys.prvt_advisor.task_ctx_type,
find_similar IN     BOOLEAN,
ename        IN     VARCHAR2,
facility     IN     VARCHAR2,
msg_num      IN     NUMBER,
arg1         IN     VARCHAR2,
arg2         IN     VARCHAR2,
arg3         IN     VARCHAR2,
arg4         IN     VARCHAR2,
arg5         IN     VARCHAR2,
header       IN     NUMBER,
mlm          IN     NUMBER,
mnl          IN     NUMBER,
mseq         IN     NUMBER)
RETURN NUMBER;
TBD
 
INSERT_OBJECT
Undocumented prvt_advisor.insert_object(
task_ctx IN OUT sys.prvt_advisor.task_ctx_type,
ename    IN     VARCHAR2,
p_type   IN     NUMBER,
p_attr1  IN     VARCHAR2,
p_attr2  IN     VARCHAR2,
p_attr3  IN     VARCHAR2,
p_attr4  IN     CLOB,
p_attr5  IN     VARCHAR2,
p_attr6  IN     RAW,
p_attr7  IN     NUMBER,
p_attr8  IN     NUMBER,
p_attr9  IN     NUMBER,
p_attr10 IN     NUMBER,
p_attr11 IN     NUMBER,
p_attr12 IN     NUMBER,
p_attr13 IN     NUMBER,
p_attr14 IN     NUMBER,
p_attr15 IN     NUMBER,
p_attr16 IN     VARCHAR2,
p_attr17 IN     VARCHAR2,
p_attr18 IN     VARCHAR2,
p_attr19 IN     VARCHAR2,
p_attr10 IN     VARCHAR2,
p_other  IN     CLOB)
RETURN NUMBER;
TBD
 
INSERT_REC_ACT
Undocumented prvt_advisor.insert_rec_act(
task_id     IN NUMBER,
finding_id  IN NUMBER,
ename       IN VARCHAR2,
rec_id      IN NUMBER,
benefit     IN NUMBER,
benefit_msg IN NUMBER,
rec_type    IN VARCHAR2,
act_id      IN NUMBER,
act_message IN NUMBER,
command_id  IN NUMBER,
attr1       IN VARCHAR2,
attr2       IN VARCHAR2,
attr3       IN VARCHAR2);
TBD
 
INTERRUPT_TASK
Undocumented prvt_advisor.interrupt_task(
task_name     IN VARCHAR2,
task_owner_id IN BINARY_INTEGER);
TBD
 
IS_EMPTY
Undocumented prvt_advisor.is_empty(
name         IN  VARCHAR2,
display_name OUT VARCHAR2)
RETURN BOOLEAN;
TBD
 
IS_KEYWORD
Undocumented, but clearly not related to the list of reserved words prvt_advisor.is_keyword(
name         IN  VARCHAR2,
display_name OUT VARCHAR2)
RETURN BOOLEAN;
DECLARE
 dispName v$reserved_words.keyword%TYPE;
BEGIN
  IF prvt_advisor.is_keyword('SELECT', dispName) THEN
    dbms_output.put_line(dispName);
  ELSE
    dbms_output.put_line('Name Not Found');
  END IF;
END;
/
Name Not Found

PL/SQL procedure successfully completed.
 
IS_PACK_ENABLED
Undocumented prvt_advisor.is_pack_enabled(pack_name IN VARCHAR2) RETURN BOOLEAN;
BEGIN
  IF prvt_advisor.is_pack_enabled('TUNING') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.
 
IS_WILDCARD
Undocumented prvt_advisor.is_wildcard(
name         IN  VARCHAR2,
display_name OUT VARCHAR2)
RETURN BOOLEAN;
TBD
 
MARK_RECOMMENDATION
Undocumented prvt_advisor.mark_recommendation(
task_name     IN VARCHAR2,
id            IN NUMBER,
action        IN VARCHAR2,
task_owner_id IN BINARY_INTEGER);
TBD
 
PARSE_NAME
Undocumented prvt_advisor.parse_name(
name IN VARCHAR2,
prop IN BINARY_INTEGER);
TBD
 
QUICK_TUNE
Undocumented prvt_advisor.quick_tune(
advisor_name  IN VARCHAR2,
task_name     IN VARCHAR2,
attr1         IN CLOB,
attr2         IN VARCHAR2,
attr3         IN NUMBER,
template      IN VARCHAR2,
implement     IN BOOLEAN,
descr         IN VARCHAR2,
task_owner_id IN BINARY_INTEGE);
TBD
 
RECORD_ERRORMSG
Undocumented prvt_advisor.record_errormsg(
task_num  IN BINARY_INTEGER,
exec_name IN VARCHAR2,
err_num   IN BINARY_INTEGER);
TBD
 
RECORD_JOURNAL
Undocumented prvt_advisor.record_journal(
task_id  IN BINARY_INTEGER,
jou_type IN BINARY_INTEGER,
code     IN VARCHAR2,
arg1     IN VARCHAR2,
arg2     IN VARCHAR2,
arg3     IN VARCHAR2,
arg4     IN VARCHAR2,
arg5     IN VARCHAR2);
TBD
RECOVER_SINGLE_STALE_TASK
Undocumented prvt_advisor.recover_single_stale_task(
task_id      IN NUMBER,
acquire_lock IN BOOLEAN);
TBD
 
RECOVER_STALE_TASKS
Undocumented prvt_advisor.recover_stale_tasks;
exec prvt_advisor.recover_stale_tasks;

PL/SQL procedure successfully completed.
 
RESET_TASK
Undocumented

Overload 1
prvt_advisor.reset_task(
task_name     IN VARCHAR2,
prop          IN BINARY_INTEGER,
task_owner_id IN BINARY_INTEGER);
TBD
Overload 2 prvt_advisor.reset_task(task_num IN BINARY_INTEGER);
TBD
 
RESTORE_NLS_NUMBER_ENV
Undocumented prvt_advisor.restore_nls_number_env(original_value IN VARCHAR2);
TBD
 
SETUP_NLS_NUMBER_ENV
Undocumented prvt_advisor.setup_nls_number_env(original_value IN OUT VARCHAR2) RETURN BOOLEAN;
TBD
 
SETUP_USER_ENVIRONMENT
Undocumented prvt_advisor.setup_user_environment(
advisor_name IN VARCHAR2,
user_id      IN BINARY_INTEGER);
SELECT UNIQUE owner, advisor_name
FROM dba_advisor_tasks;

OWNER  ADVISOR_NAME
------ ---------------------
SYS    SQL Tuning Advisor
SYS    SPM Evolve Advisor
SYS    ADDM
SYS    Statistics Advisor


exec prvt_advisor.setup_user_environment('SQL Tuning Advisor', '0');

PL/SQL procedure successfully completed.
 
SET_DEFAULT_TASK_PARAMETER
Undocumented

Overload 1
prvt_advisor.set_default_task_parameter(
advisor_name IN VARCHAR2,
parameter    IN VARCHAR2,
value        IN VARCHAR2);
TBD
Overload 2 prvt_advisor.set_default_task_parameter(
advisor_name IN VARCHAR2,
parameter    IN VARCHAR2,
value        IN NUMBER);
TBD
 
SET_TASK_PARAMETER
Undocumented

Overload 1
prvt_advisor.set_task_parameter(
task_name     IN VARCHAR2,
parameter     IN VARCHAR2,
data          IN VARCHAR2,
prop          IN BINARY_INTEGER,
scope         IN BINARY_INTEGER,
task_owner_id IN BINARY_INTEGER);
TBD
Overload 2 prvt_advisor.set_task_parameter(
task_name     IN VARCHAR2,
parameter     IN VARCHAR2,
data          IN NUMBER,
prop          IN BINARY_INTEGER,
scope         IN BINARY_INTEGER,
task_owner_id IN BINARY_INTEGER);
TBD
 
SIGNAL_INTERRUPT
Undocumented prvt_advisor.signal_interrupt(
task_id     IN BINARY_INTEGER,
intr_option IN BINARY_INTEGER);
TBD
 
TEST_EXECUTE_TASK
Undocumented prvt_advisor.test_execute_task(
task_name   IN VARCHAR2,
test_id     IN BINARY_INTEGER,
raise_error IN BINARY_INTEGER,
user_id     IN BINARY_INTEGER);
TBD
 
TRACK_REPORT_USAGE
Undocumented prvt_advisor.track_report_usage(advisor_id IN NUMBER);
SELECT UNIQUE advisor_id
FROM dba_advisor_tasks;

ADVISOR_ID
----------
         1
        11
        12
         4


exec prvt_advisor.track_report_usage(4);

PL/SQL procedure successfully completed.
 
UPDATE_ACTION
Undocumented prvt_advisor.update_action(
task_ctx            IN sys.prvt_advisor.task_ctx_type,
action_id           IN NUMBER,
ename               IN VARCHAR2,
p_obj_id            IN NUMBER,
p_command           IN NUMBER,
p_flags             IN NUMBER,
p_attr1             IN VARCHAR2,
p_attr2             IN VARCHAR2,
p_attr3             IN VARCHAR2,
p_attr4             IN VARCHAR2,
p_attr5             IN CLOB,
p_attr6             IN CLOB,
p_num_attr1         IN NUMBER,
p_num_attr2         IN NUMBER,
p_num_attr3         IN NUMBER,
p_num_attr4         IN NUMBER,
p_num_attr5         IN NUMBER,
p_msg_id            IN NUMBER,
p_filtered          IN CHAR,
p_res_status#       IN NUMBER,
p_res_last_modified IN TIMESTAMP,
p_res_msg_id        IN NUMBER);
TBD
 
UPDATE_DIRECTIVE
Undocumented prvt_advisor.update_directive(
directive_id  IN BINARY_INTEGER,
instance_name IN VARCHAR2,
task_name     IN VARCHAR2,
document      IN CLOB,
task_owner_id IN BINARY_INTEGER);
TBD
 
UPDATE_OBJECT
Undocumented

Overload 1
prvt_advisor.update_object(
task_name     IN VARCHAR2,
object_id     IN NUMBER,
a1            IN VARCHAR2,
a2            IN VARCHAR2,
a3            IN VARCHAR2,
a4            IN CLOB,
a5            IN VARCHAR2,
a11           IN NUMBER,
task_owner_id IN BINARY_INTEGER);
TBD
Overload 2 prvt_advisor.update_object(
task_ctx  IN sys.prvt_advisor.task_ctx_type,
object_id IN NUMBER,
ename     IN VARCHAR2,
p_attr1   IN VARCHAR2,
p_attr2   IN VARCHAR2,
p_attr3   IN VARCHAR2,
p_attr4   IN CLOB,
p_attr5   IN VARCHAR2,
p_attr6   IN RAW,
p_attr7   IN NUMBER,
p_attr8   IN NUMBER,
p_attr9   IN NUMBER,
p_attr10  IN NUMBER,
p_attr11  IN NUMBER,
p_attr12  IN NUMBER,
p_attr13  IN NUMBER,
p_attr14  IN NUMBER,
p_attr15  IN NUMBER,
p_attr16  IN VARCHAR2,
p_attr17  IN VARCHAR2,
p_attr18  IN VARCHAR2,
p_attr19  IN VARCHAR2,
p_attr20  IN VARCHAR2,
p_other   IN CLOB);
TBD
 
UPDATE_REC_ATTRIBUTES
Undocumented prvt_advisor.update_rec_attributes(
task_name      IN VARCHAR2,
rec_id         IN NUMBER,
action_id      IN NUMBER,
attribute_name IN VARCHAR2,
value          IN VARCHAR2,
task_owner_id  IN BINARY_INTEGER);
TBD
 
UPDATE_TASK
Undocumented

Overload 1
prvt_advisor.update_task(
task_id     IN BINARY_INTEGER,
new_status  IN BINARY_INTEGER,
new_cleanup IN BINARY_INTEGER,
db_version  IN BINARY_INTEGER);
TBD
Overload 2 prvt_advisor.update_task(
task_id        IN BINARY_INTEGER,
last_execution IN VARCHAR2,
new_status     IN BINARY_INTEGER,
new_cleanup    IN BINARY_INTEGER,
db_version     IN BINARY_INTEGER);
TBD
 
UPDATE_TASK_ATTRIBUTES
Undocumented prvt_advisor.update_task_attributes(
task_name     IN VARCHAR2,
new_name      IN VARCHAR2,
description   IN VARCHAR2,
read_only     IN VARCHAR2,
is_template   IN VARCHAR2,
how_created   IN VARCHAR2,
prop          IN BINARY_INTEGER,
source        IN VARCHAR2,
task_owner_id IN BINARY_INTEGER);
TBD
 
VALIDATE_ADVISOR
Undocumented prvt_advisor.validate_advisor(advisor_name IN VARCHAR2) RETURN sys.wri$_adv_abstract_t;
TBD
 
VALIDATE_COMMAND
Undocumented prvt_advisor.validate_command(command IN VARCHAR2) RETURN BINARY_INTEGER;
TBD
 
VALIDATE_EXECUTION
Undocumented prvt_advisor.validate_execution(
task_id_num    IN BINARY_INTEGER,
execution_name IN VARCHAR2,
execution_type IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
VALIDATE_EXECUTION_ID
Undocumented prvt_advisor.validate_execution_id(
task_id      IN BINARY_INTEGER,
task_name    IN VARCHAR2,
execution_id IN BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
VALIDATE_EXECUTION_OBJECT
Undocumented prvt_advisor.validate_execution_object(
task_name      IN VARCHAR2,
task_id_num    IN BINARY_INTEGER,
execution_name IN VARCHAR2,
object_id      IN BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
VALIDATE_EXECUTION_ORDER
Undocumented prvt_advisor.validate_execution_order(
tid        IN NUMBER,
begin_exec IN VARCHAR2,
end_exec   IN VARCHAR2);
TBD
 
VALIDATE_ITEM_LENGTH
Undocumented prvt_advisor.validate_item_length(
value   IN VARCHAR2,
name_id IN VARCHAR2,
max_len IN BINARY_INTEGER);
TBD
 
VALIDATE_NEW_TASK
Undocumented prvt_advisor.validate_new_task(
task_name    IN VARCHAR2,
task_num     IN NUMBER,
prop         IN BINARY_INTEGER,
advisor_name IN VARCHAR2,
user_id      IN BINARY_INTEGER)
RETURN VARCHAR2;
TBD
 
VALIDATE_TASK
Undocumented prvt_advisor.validate_task(
task_name    IN VARCHAR2,
prop         IN BINARY_INTEGER,
user_id      IN BINARY_INTEGER,
advisor_name IN VARCHAR2);
TBD
 
VALIDATE_TASK_ID
Undocumented prvt_advisor.validate_task_id(
task_id       IN  BINARY_INTEGER,
task_name     OUT VARCHAR2,
task_owner    OUT VARCHAR2,
task_owner_id OUT NUMBER);
TBD
 
VALIDATE_USERNAME
Undocumented prvt_advisor.validate_username(
user_name    IN VARCHAR2,
container_id IN NUMBER)
RETURN NUMBER;
TBD

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