Oracle PRVT_ILM
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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