Oracle PRVT_ILM
Version 18.3.0.1

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 Support utilities for DBMS_ILM; Integrated Lifecycle Management
AUTHID DEFINER
Data Types TYPE ilmobj IS PLSQL_RECORD ...

TYPE ilm_objpolicy_info IS PLSQL_RECORD ...

TYPE ilm_tab_objpolicy_info IS TABLE OF ...

TYPE jobresult IS PLSQL_RECORD ...

TYPE obj_stat IS PLSQL_RECORD ...

TYPE policy_context IS PL/SQL RECORD ...

TYPE tab_eval_objpolicy_info IS TABLE OF ...

TYPE tab_action IS PLSQL_TABLE OF ...

TYPE tab_depobjstate is TABLE OF ...

TYPE tab_iden is TABLE OF ...

TYPE tab_ilmjob is TABLE OF ...

TYPE tab_ilmjob_short IS TABLE OF ...

TYPE tab_numbers IS TABLE OF ...

TYPE tab_objpolupdate IS TABLE OF ...

TYPE tab_obj_stat_hash IS PLSQL TABLE OF ...

TYPE tab_par_jobinfo IS TABLE OF ...

TYPE tab_polname IS PLSQL TABLE OF ...

TYPE tab_rid_pair IS TABLE OF ...

TYPE tab_tbs_stats IS TABLE OF ...

CREATE OR REPLACE NONEDITIONABLE TYPE sys.objrank FORCE IS
OBJECT(rank number, obj# number);

CREATE OR REPLACE NONEDITIONABLE TYPE sys.tabobj#
AS TABLE OF objrank;
Dependencies
AQ$_descrIPTOR DBMS_ILM_ADMIN INDCOMPART$
AQ$_REG_INFO DBMS_INMEMORY INDPART$
COL$ DBMS_OUTPUT INDSUBPART$
COLLECT DBMS_ROWID LOB$
CSVLIST DBMS_SCHEDULER LOBCOMPPART$
DBA_DATA_FILES DBMS_SPACE_ADMIN LOBFRAG$
DBA_EXTENTS DBMS_SYSTEM OBJ$
DBA_FREE_SPACE DBMS_SYS_SQL OBJRANK
DBA_ILMOBJECTS DBMS_UTILITY PLITBLM
DBA_ILMPARAMETERS DEFERRED_STG$ REDEF_OBJECT$
DBA_INDEXES DUAL SCHEDULER$_EVENT_INFO
DBA_IND_PARTITIONS HEAT_MAP_STAT$ SEG$
DBA_OBJECTS ILM$ SYS_NT_COLLECT
DBA_SCHEDULER_JOBS ILMOBJ$ TAB$
DBA_SCHEDULER_JOB_RUN_DETAILS ILMPOLICY$ TABCOMPART$
DBA_SCHEDULER_WINDOWS ILM_CONCURRENCY$ TABOBJ#
DBA_SCHEDULER_WINGROUP_MEMBERS ILM_DEPENDANT_OBJ$ TABPART$
DBA_TABLES ILM_DEP_EXECUTIONDETAILS$ TABSUBPART$
DBA_TAB_COLS ILM_EXECUTION$ TS$
DBA_TAB_PARTITIONS ILM_EXECUTIONDETAILS$ USER$
DBA_TAB_SUBPARTITIONS ILM_EXECUTIONID USER_ILMEVALUATIONDETAILS
DBMS_AQ ILM_PARAM$ USER_ILMRESULTS
DBMS_ASSERT ILM_RESULTS$ V$DATABASE
DBMS_ILM IND$ _SYS_HEAT_MAP_SEG_HISTOGRAM
Documented No
First Available 12.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtilm.plb
Subprograms
 
ADO_ENVPARAMS
Undocumented prvt_ilm.ado_envParams(
p_jobsizelimit OUT NUMBER,
p_deg_parallel OUT NUMBER);
DECLARE
 jslimit NUMBER;
 degpara NUMBER;
BEGIN
  prvt_ilm.ado_envParams(jslimit, degpara);
  dbms_output.put_line(jslimit);
  dbms_output.put_line(degpara);
END;
/
-1
1
 
CHECK_CONFLICT
Checks for a conflict between two ILM objects and returns 1 if a conflict is found prvt_ilm.check_conflict(
obj1 IN sys.prvt_ilm.ilmobj,
obj2 IN sys.prvt_ilm.ilmobj)
RETURN NUMBER;
TBD
 
CREATE_JOBS_REBUILD_DEP
Undocumented
Overload 1
prvt_ilm.create_jobs_rebuild_dep(
p_tab_par_jobinfo IN sys.prvt_ilm.tab_par_jobinfo);
TBD
Overload 2 prvt_ilm.create_jobs_rebuild_dep(p_jobname IN VARCHAR2);
TBD
 
 
CREATE_JOB_DEP
Undocumented prvt_ilm.create_job_dep(
P_PARJOBNAME   IN VARCHAR2,
p_jobname      IN VARCHAR2,
P_payload      IN CLOB,
p_tab_numbers  IN sys.prvt_ilm.tab_numbers,
p_execution_id IN NUMBER)
RETURN BOOLEAN;
TBD
CREATE_TAB_ILMJOB
Undocumented prvt_ilm.create_tab_ilmJob(
p_tab_ilmjob   IN OUT sys.prvt_ilm.tab_ilmjob,
p_execution_id IN     NUMBER);
TBD
 
DEPOBJ_STATE
Undocumented
Overload 1
prvt_ilm.depobj_state(jobname IN VARCHAR2)
RETURN NUMBER;
TBD
Overload 2 prvt_ilm.depobj_state(
tab_jobname IN sys.prvt_ilm.tab_iden)
RETURN sys.prvt_ilm.tab_depobjstate);
TBD
 
DETERMINE_CONFLICT
Undocumented prvt_ilm.determine_conflict(
obj1 IN sys.prvt_ilm.ilmobj,
obj2 IN sys.prvt_ilm.ilmobj)
RETURN NUMBER;
TBD
 
DISABLE_TAB_OBJPOLICY
Undocumented prvt_ilm.disable_tab_objPolicy(
p_tab_objpolupdate IN sys.prvt_ilm.tab_objpolupdate);
TBD
 
EVALUATE_ILM_POLICIES
Undocumented prvt_ilm.evaluate_ilm_policies(
p_tab_objpolicy_info IN OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  IN     sys.prvt_ilm.tab_obj_stat_hash,
p_user               IN     VARCHAR2,
p_ignore_recent_ilm  IN     BOOLEAN);
TBD
 
EXECUTE_ILM_POLICIES
Undocumented

Overload 1
prvt_ilm.execute_ilm_policies(
p_tab_objpolicy_info     IN OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash      IN     sys.prvt_ilm.tab_obj_stat_hash,
p_user                   IN     VARCHAR2,
p_ignore_recent_ilm      IN     BOOLEAN,
p_jobs                   IN     NUMBER,
p_heavyjobs_in_ilmwindow IN     BOOLEAN,
execmode                 IN     NUMBER,
execution_id                OUT NUMBER);
TBD
Overload 2 prvt_ilm.execute_ilm_policies(
p_tab_objpolicy_info     IN OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash      IN     sys.prvt_ilm.tab_obj_stat_hash,
p_ignore_recent_ilm      IN     BOOLEAN,
p_jobs                   IN     NUMBER,
p_heavyjobs_in_ilmwindow IN     BOOLEAN,
execmode                 IN     NUMBER,
execution_id             IN     NUMBER);
TBD
 
EXECUTE_ILM_SCH
Undocumented prvt_ilm.execute_ilm_sch(
njobs        IN NUMBER,
execmode     IN NUMBER,
policy_flags IN NUMBER);
TBD
 
EXECUTE_TASK
Undocumented prvt_ilm.execute_task(
P_task_id  IN NUMBER,
njobs      IN NUMBER,
REEVALUATE IN BOOLEAN);
TBD
 
EXEC_ilm_action
Undocumented prvt_ilm.exec_ilm_action(
P_ACTION IN NUMBER,
P_POLCTX IN sys.prvt_ilm.policy_context);
TBD
 
FILTER_BY_WEIGHT
Undocumented prvt_ilm.filter_by_weight(
p_tab_objpolicy_info IN OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  IN     sys.prvt_ilm.tab_obj_stat_hash);
TBD
 
FILTER_FOR_MOVE
Undocumented prvt_ilm.filter_for_move(
p_tab_objpolicy_info IN OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  IN     sys.prvt_ilm.tab_obj_stat_hash);
RETURN BOOLEAN;
TBD
 
GEN_EXECUTION_ID
Returns an execution identifier prvt_ilm.gen_execution_id RETURN NUMBER;
col sequence_owner format a30
col sequence_name format a30

SELECT sequence_owner, sequence_name, last_number
FROM dba_sequences
WHERE sequence_name LIKE '%ILM%';

SEQUENCE_OWNER                 SEQUENCE_NAME                  LAST_NUMBER
------------------------------ ------------------------------ -----------
SYS                            ILM_SEQ$                                 1
SYS                            ILM_EXECUTIONID                          1

SQL> SELECT prvt_ilm.gen_execution_id
  2  FROM dual;

GEN_execution_id
----------------
               1

SQL> /

GEN_execution_id
----------------
               2

SQL> /

GEN_execution_id
----------------
               3

SELECT sequence_owner, sequence_name, last_number
FROM dba_sequences
WHERE sequence_name LIKE '%ILM%';

SEQUENCE_OWNER                 SEQUENCE_NAME                  LAST_NUMBER
------------------------------ ------------------------------ -----------
SYS                            ILM_SEQ$                                 1
SYS                            ILM_EXECUTIONID                         21
 
GEN_RID_RANGE
Undocumented prvt_ilm.gen_rid_range(
ownname      IN VARCHAR2,
objname      IN VARCHAR2,
max_bytes    IN NUMBER,
partname     IN VARCHAR2,
objd         IN NUMBER,
min_rfn      IN NUMBER,
min_block_id IN NUMBER)
RETURN sys.prvt_ilm.tab_rid_pair;
TBD
 
GETSECTICK
Undocumented prvt_ilm.getSecTick(time OUT NUMBER);
DECLARE
 outVal NUMBER;
BEGIN
  prvt_ilm.getSecTick(outVal);
  dbms_output.put_line(outVal);
END;
/
1555685282

PL/SQL procedure successfully completed.

SQL> /
1555685292

PL/SQL procedure successfully completed.
 
GET_EVALUATEDTASK_JOB_INFO
Undocumented prvt_ilm.get_evaluatedTask_job_info(
task_id IN NUMBER,
n_jobs  IN NUMBER)
RETURN sys.prvt_ilm.tab_ilmjob;
TBD
 
GET_EVAL_INFO
Undocumented prvt_ilm.get_eval_info(
p_execution_id IN NUMBER,
p_nobj         IN NUMBER)
RETURN sys.prvt_ilm.tab_eval_objpolicy_info;
TBD
 
GET_ILMOBJ_TAB
Undocumented prvt_ilm.get_ilmObj_tab RETURN sys.prvt_ilm.tab_ilmobj;
DECLARE
 retVal sys.prvt_ilm.tab_ilmobj;
BEGIN
  retVal := prvt_ilm.get_ilmObj_tab;
END;
/
 
GET_IMCMPLEVEL
Undocumented prvt_ilm.get_imcmpLevel(ctype IN NUMBER)
RETURN NUMBER;
SELECT prvt_ilm.get_imcmpLevel(0)
FROM dual;

PRVT_ILM.GET_IMCMPLEVEL(-1)
---------------------------
                          0

SELECT prvt_ilm.get_imcmpLevel(1)
FROM dual;

PRVT_ILM.GET_IMCMPLEVEL(-1)
---------------------------
                          0

SELECT prvt_ilm.get_imcmpLevel(-1)
FROM dual;

PRVT_ILM.GET_IMCMPLEVEL(-1)
---------------------------
                          0

SELECT prvt_ilm.get_imcmpLevel(-1000)
FROM dual;

PRVT_ILM.GET_IMCMPLEVEL(-1)
---------------------------
                          0
 
GET_JOB_INFO
Undocumented prvt_ilm.gegt_job_info(
p_execution_id   IN NUMBER,
p_execution_flag IN NUMBER,
P_JOBTYPE        IN NUMBER,
P_JOBTYPE1       IN NUMBER,
p_jobname        IN VARCHAR2)
RETURN sys.prvt_ilm.tab_ilmjob_short;
TBD
 
GET_NEXTN_OBJ
Undocumented

Overload 1
prvt_ilm.get_nextn_obj(
ilm_scope         IN NUMBER,
nextn             IN NUMBER,
v_user#           IN NUMBER,
ignore_recent_ilm IN BOOLEAN)
RETURN sys.tabobj#;
TBD
Overload 2 prvt_ilm.get_nextn_obj(
p_execution_id IN NUMBER,
nextn          IN NUMBER)
RETURN sys.tabobj#;
TBD
 
GET_NEXTN_OBJPOL
Undocumented prvt_ilm.get_nextn_objpol(
p_jobs              IN  NUMBER,
p_ilm_tab_objpolicy OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash OUT sys.prvt_ilm.tab_obj_stat_hash,
p_flagS             IN  NUMBER);
TBD
 
GET_OBJPOLICY_STAT
Undocumented prvt_ilm.get_objPolicy_stat(
p_tabobj#            IN     sys.tabobj#,
p_tab_objpolicy_stat IN OUT sys.prvt_ilm.tab_obj_policy_stat);
TBD
 
GET_OBJ_STAT
Undocumented

Overload 1
prvt_ilm.get_obj_stat(v_tabobj# IN sys.tabobj#)
RETURN sys.prvt_ilm.tab_obj_stat_hash;
TBD
Overload 2 prvt_ilm.get_obj_stat(obj# IN NUMBER)
RETURN sys.prvt_ilm.tab_obj_stat_hash;
TBD
Overload 3 prvt_ilm.get_obj_stat(p_policy# IN NUMBER)
RETURN sys.prvt_ilm.tab_obj_stat_hash;
TBD
 
GET_POLICY_INFO
Undocumented

Overload 1
prvt_ilm.get_policy_info(
ilm_scope            IN  BINARY_INTEGER,
p_user               IN  VARCHAR2,
p_tab_objpolicy_info OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  OUT sys.prvt_ilm.tab_obj_stat_hash,
p_nobj               IN  NUMBER,
p_ignore_recent_ilm  IN  BOOLEAN,
p_flags              IN  NUMBER);
TBD
Overload 2 prvt_ilm.get_policy_info(
objowner             IN  VARCHAR2,
object_name          IN  VARCHAR2,
subobject_name       IN  VARCHAR2,
p_user               IN  VARCHAR2,
p_tab_objpolicy_info OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  OUT sys.prvt_ilm.tab_obj_stat_hash,
isdba                IN  BOOLEAN,
P_policy_name        IN  VARCHAR2);
TBD
Overload 3 prvt_ilm.get_policy_info(
policy_name          IN  VARCHAR2,
p_user               IN  VARCHAR2,
p_tab_objpolicy_info OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  OUT sys.prvt_ilm.tab_obj_stat_hash);
TBD
Overload 4 prvt_ilm.get_policy_info(
execution_id         IN  NUMBER,
p_tab_objpolicy_info OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  OUT sys.prvt_ilm.tab_obj_stat_hash,
p_nobj               IN  NUMBER);
TBD
Overload 5 prvt_ilm.get_policy_info(
p_tabobj#            IN  sys.tabobjJ#,
p_tab_objpolicy_info OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
P_policy_name        IN  VARCHAR2,
p_flags              IN  NUMBER);
TBD
 
GET_STAT_TjIME
Undocumented prvt_ilm.get_stat_time(
p_objpolicy_info IN sys.prvt_ilm.ilm_objpolicy_info,
p_obj_stat       IN sys.prvt_ilm.obj_stat)
RETURN TIMESTAMP;
TBD
 
GET_WEIGHT
Undocumented prvt_ilm.ge_weight(
p_objpolicy_info IN OUT sys.prvt_ilm.ilm_objpolicy_info)
RETURN NUMBER;
TBD
 
HEAT_MAP_ON
Undocumented prvt_ilm.heat_map_on(
p_heat_map_on      OUT BOOLEAN,
p_heat_map_on_TIME OUT TIMESTAMP);
DECLARE
 phmo  BOOLEAN;
 phmot TIMESTAMP;
BEGIN
  prvt_ilm.heat_map_on(phmo, phmot);
  IF phmo THEN
    dbms_output.put_line('Heat Maps Is On');
  ELSE
    dbms_output.put_line('Heat Maps Is Off');
  END IF;
  dbms_output.put_line(phmot);
END;
/
Heat Maps Is Off
30-MAR-18 10.07.36.000000 PM


PL/SQL procedure successfully completed.
 
ILMJOBEXISTS
Undocumented

Overload 1
prvt_ilm.ilmJobExists(
v_objpolicyinfo IN sys.prvt_ilm.ilm_objpolicy_info)
RETURN BOOLEAN;
TBD
Overload 2 prvt_ilm.ilmJobExists(objn IN NUMBER)
RETURN BOOLEAN;
BEGIN
  IF prvt_ilm.ilmJobExists(77431) THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F
 
ILM_AUTHORIZE
Undocumented prvt_ilm.ilm_authorize(
p_user     IN VARCHAR2,
ilm_action IN NUMBER)
RETURN BOOLEAN;
TBD
 
ILM_CALLBACK
Undocumented prvt_ilm.ilm_callback(
context  IN RAW,
reginfo  IN sys.aq$_reg_info,
descr    IN sys.aq$_descriptor,
payload  IN RAW,
payloadl IN NUMBER);
TBD
 
ILM_CLEANUP
Undocumented prvt_ilm.ilm_cleanup;
exec prvt_ilm.ilm_cleanup;
 
ILM_CONSISTENCY
Undocumented prvt_ilm.ilm_consistency;
exec prvt_ilm.ilm_consistency;
 
ILM_DICT_CLEANUP
Undocumented prvt_ilm.ilm_dict_cleanup(assert_only IN BOOLEAN);
exec prvt_ilm.ilm_dict_cleanup(FALSE);
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.PRVT_ILM", line 5247
ORA-06512: at "SYS.PRVT_ILM", line 5144
ORA-06512: at line 1
 
ILM_DICT_CLEANUP_CHECK
Undocumented prvt_ilm.ilm_dict_cleanup_check(
ilm_upgrade IN BOOLEAN,
assert_only IN BOOLEAN);
exec prvt_ilm.ilm_dict_cleanup_check(TRUE, TRUE);
 
ILM_JOBCOMPLETION
Undocumented

Overload 1
prvt_ilm.ilm_jobCompletion(p_jobresult IN sys.prvt_ilm.jobresult);
TBD
Overload 2 prvt_ilm.ilm_jobCompletion(p_tabdepobjresult IN sys.prvt_ilm.tabjobresult);
TBD
 
ILM_RESOLVETASKS
Undocumented prvt_ilm.ilm_resolveTasks(n_tasks IN NUMBER);
exec prvt_ilm.ilm_resolveTasks(4);
 
ILM_TASKCOMPLETE
Returns TRUE if an ILM task has been completed prvt_ilm.ilm_taskComplete(task_id IN NUMBER)
RETURN BOOLEAN;
DECLARE
 retVal BOOLEAN;
BEGIN
  IF prvt_ilm.ilm_taskComplete(648) THEN
    dbms_output.put_line(Completed');
  ELSE
    dbms_output.put_line(Not Completed');
  END IF;
END;
/
 
INIT_ACT
Undocumented prvt_ilm.init_act(
p_tab_action IN OUT sys.prvt_ilm.tab_action);
TBD
 
INIT_PNAME
Undocumented prvt_ilm.init_pname(
p_tab_name IN OUT sys.prvt_ilm.tab_polname);
TBD
 
INSERT_TAB_ILMJOB
Undocumented prvt_ilm.insert_tab_ILMjob(
p_tab_objpolicy_info     IN sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_ilmjob             IN sys.prvt_ilm.tab_ilmjob,
p_execution_id           IN NUMBER,
p_heavyjobs_in_ilmwindow IN BOOLEAN,
p_user                   IN VARCHAR2,
p_ilmtask_state          IN NUMBER,
p_creation_time          IN TIMESTAMP,
p_start_time             IN TIMESTAMP,
p_completion_time        IN TIMESTAMP);
TBD
 
INSERT_TAB_ILMTASKINFO_DDL
Undocumented prvt_ilm.insert_tab_ilmTaskInfo_DDL(
p_tab_objpolicy_info     IN sys.prvt_ilm.ilm_tab_objpolicy_info,
p_execution_id           IN NUMBER,
p_user                   IN VARCHAR2,
p_ilmtask_state          IN NUMBER,
p_creation_time          IN TIMESTAMP,
p_start_time             IN TIMESTAMP,
p_heavyjobs_in_ilmwindow IN BOOLEAN);
TBD
 
ISSUPLOGENABLED
Returns TRUE if supplemental logging is enabled prvt_ilm.isSupLogEnabled RETURN BOOLEAN;
BEGIN
  IF prvt_ilm.isSupLogEnabled THEN
    dbms_output.put_line('Supplemental Logging Is Enabled');
  ELSE
    dbms_output.put_line('Supplemental Logging Is Not Enabled');
  END IF;
END;
/
Supplemental Logging Is Enabled
 
IS_FILTER_CANDIDATE
Undocumented prvt_ilm.is_filter_candidate(
p_objpolicy_info IN sys.prvt_ilm.ilm_objpolicy_info)
RETURN BOOLEAN;
TBD
 
LOCK_ILM_DICT
Undocumented prvt_ilm.lock_ilm_dict(p_tabobj# IN sys.tabobj#);
TBD
 
POPULATE_GRP_DEP
Undocumented prvt_ilm.populate_grp_dep(
p_tab_objpolicy_info IN sys.prvt_ilm.ilm_tab_objpolicy_info,
p_tab_obj_stat_hash  IN sys.prvt_ilm.tab_obj_stat_hash);
TBD
 
POPULATE_TBS_STAT
Undocumented prvt_ilm.populate_tbs_stat(
v_tab_obj_stat IN sys.prvt_ilm.tab_obj_stat);
TBD
 
PREVIEW_ILM
Undocumented prvt_ilm.preview_ilm(
p_ilm_scope       IN  BINARY_INTEGER,
p_user            IN  VARCHAR2,
p_execution_id    OUT BINARY_INTEGER,
ignore_recent_ilm IN  BOOLEAN);
TBD
 
PRINT_ADO_INFO
Undocumented prvt_ilm.print_ado_info;
exec prvt_ilm.print_ado_info;
 
PRINT_ILMOBJ
Undocumented prvt_ilm.print_ILMobj(obj IN sys.prvt_ilm.ilmobj);
TBD
 
PRINT_OBJPOLICY_INFO
Undocumented prvt_ilm.print_objPolicy_info(
v_objpolicy   IN sys.prvt_ilm.ilm_objpolicy_info,
v_flag        IN NUMBER,
v_trace_level IN NUMBER);
TBD
 
PRINT_TAB_ADOJOB
Undocumented prvt_ilm.print_tab_ADOjob(
v_tab_ilmjob IN sys.prvt_ilm.tab_ilmjob,
v_flag       IN NUMBER);
TBD
 
PRINT_TAB_NUMBERS
Undocumented prvt_ilm.print_tab_numbers(tabobj# IN sys.prvt_ilm.tabobj#);
TBD
 
PRINT_TAB_OBJPOLICY_INFO
Undocumented prvt_ilm.print_tab_objPolicy_info(
v_info IN sys.prvt_ilm.ilm_tab_objpolicy_info,
v_flag IN NUMBER);
TBD
 
PRINT_TAB_OBJPOLICY_STAT
Undocumented prvt_ilm.print_tab_objPolicy_stat(
v_info IN sys.prvt_ilm.tab_obj_policy_stat,
v_flag IN NUMBER);
TBD
 
PRINT_TAB_RID
Undocumented prvt_ilm.print_tab_rid(
p_tab_rid IN sys.prvt_ilm.tab_rid_pair);
TBD
 
PRINT_TBS_STAT
Undocumented prvt_ilm.print_tbs_stat(
v_tab_tbs_stat IN sys.prvt_ilm.tab_tbs_stat);
TBD
 
PURGE_ILM
Sets the ILM purge latency prvt_ilm.purge_ilm(n_days IN NUMBER);
exec prvt_ilm.purge_ilm(32);
 
REMOVE_FROM_ILM
Undocumented prvt_ilm.remove_from_ilm(
p_execution_id IN NUMBER,
p_obj#         IN sys.prvt_ilm.tab_numbers);
TBD
 
SCHEDULE_COLSTATS_FLUSH
Schedules a column stats flush prvt_ilm.schedule_colstats_flush;
exec prvt_ilm.schedule_colstats_flush;
 
SCHEDULE_ROWMAPS_FLUSH
Schedules a rowmaps stats flush prvt_ilm.schedule_rowmaps_flush;
exec prvt_ilm.schedule_rowmaps_flush;
 
SCHEDULE_SEGMENTS_FLUSH
Schedules a segments stats flush prvt_ilm.schedule_segments_flush;
exec prvt_ilm.schedule_segments_flush;
 
SETDEBUG
Undocumented prvt_ilm.setDebug;
exec prvt_ilm.setDebug;
 
STOPJOBS
Undocumented prvt_ilm.stopJobs(
p_execution_id    IN NUMBER,
drop_running_jobs IN BOOLEAN,
drop_only_heavy   IN BOOLEAN,
p_flag            IN NUMBER,
p_jobname         IN VARCHAR2);
TBD
 
STOPJOBS1
Undocumented prvt_ilm.stopJobs1(
p_execution_id    IN NUMBER,
drop_running_jobs IN BOOLEAN,
drop_only_heavy   IN BOOLEAN,
p_flag            IN NUMBER,
p_jobtype1        IN NUMBER,
p_jobname         IN VARCHAR2);
TBD
 
STORE_VALID_INDEXES
Undocumented prvt_ilm.store_valid_indexes(
p_table_owner   IN VARCHAR2,
p_table_name    IN VARCHAR2,
p_job_name      IN VARCHAR2,
p_execution_id  IN VARCHAR2,
p_state         IN NUMBER,
p_n_rebuild_att IN NUMBER);
TBD
 
TRACE
Undocumented prvt_ilm.trace(
lvl        IN NUMBER,
trace_info IN VARCHAR2);
TBD
 
UPDATE_ILMEXECUTION
Undocumented prvt_ilm.update_ilmExecution(
p_tab_objpolicy_info IN sys.prvt_ilm.ilm_tab_objpolicy_info,
p_execution_id       IN BINARY_INTEGER);
TBD
 
UPDATE_JOB_STATUS
Undocumented prvt_ilm.update_job_status(
p_tabdepobjstate IN sys.prvt_ilm.tab_depObjState);
TBD
 
UPDATE_TAB_ILMJOB
Undocumented prvt_ilm.update_tab_ilmJob(
p_tab_ilmjob IN sys.prvt_ilm.tab_ilmjob);
TBD
 
VALIDATE_EXECID
Undocumented prvt_ilm.validate_execID(
p_execution_id IN  NUMBER,
p_owner        IN  NUMBER,
p_errcode      OUT NUMBER)
RETURN BOOLEAN;
TBD
 
VERIFY_PRECONDITION_POLICIES
Undocumented prvt_ilm.verify_precondition_policies(
p_tab_objpolicy_info  IN OUT sys.prvt_ilm.ilm_tab_objpolicy_info,
p_ignore_recent_ilm   IN     BOOLEAN,
p_tab_obj_stat_hash   IN     sys.prvt_ilm.tab_obj_stat_hash);
TBD
 
VERIFY_SUCCESS_POLICY
Undocumented prvt_ilm.verify_success_policy(
p_objpolicy_info IN sys.prvt_ilm.ilm_objpolicy_info);
TBD

Related Topics
ADO
Built-in Functions
Built-in Packages
DBMS_HEAT_MAP
DBMS_ILM
DBMS_ILM_ADMIN
What's New In 18cR3
What's New In 19cR3

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx