Oracle | PRVT

Oracle PRVT_ILM Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Support utilities for DBMS_ILM; Integrated Lifecycle Management

AUTHID DEFINER

Data Types TYPE act_context IS PLSQL_RECORD ... TYPE act_result IS PLSQL_RECORD ... 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

ALL_OBJECTS	DBMS_ASSERT	IND$
AQ$_DESCRIPTOR	DBMS_ILM	INDCOMPART$
AQ$_REG_INFO	DBMS_ILM_ADMIN	INDPART$
COL$	DBMS_INDEX_UTL	INDSUBPART$
COLLECT	DBMS_INMEMORY	LOB$
CSVLIST	DBMS_OUTPUT	LOBCOMPPART$
DBA_DATA_FILES	DBMS_ROWID	LOBFRAG$
DBA_EXTENTS	DBMS_SCHEDULER	OBJ$
DBA_FREE_SPACE	DBMS_SPACE_ADMIN	OBJRANK
DBA_HEAT_MAP_SEGMENT	DBMS_SYSTEM	PLITBLM
DBA_ILMOBJECTS	DBMS_SYS_SQL	REDEF_OBJECT$
DBA_ILMPARAMETERS	DBMS_UTILITY	SCHEDULER$_EVENT_INFO
DBA_INDEXES	DEFERRED_STG$	SEG$
DBA_IND_COLUMNS	DUAL	SYS_NT_COLLECT
DBA_IND_PARTITIONS	HEAT_MAP_STAT$	TAB$
DBA_OBJECTS	ILM$	TABCOMPART$
DBA_PART_INDEXES	ILMOBJ$	TABOBJ#
DBA_SCHEDULER_JOBS	ILMPOLICY$	TABPART$
DBA_SCHEDULER_JOB_RUN_DETAILS	ILM_CONCURRENCY$	TABSUBPART$
DBA_SCHEDULER_WINDOWS	ILM_DEPENDANT_OBJ$	TS$
DBA_SCHEDULER_WINGROUP_MEMBERS	ILM_DEP_EXECUTIONDETAILS$	USER$
DBA_TABLES	ILM_EXECUTION$	USER_ILMEVALUATIONDETAILS
DBA_TAB_COLS	ILM_EXECUTIONDETAILS$	USER_ILMRESULTS
DBA_TAB_PARTITIONS	ILM_EXECUTIONID	V$DATABASE
DBA_TAB_SUBPARTITIONS	ILM_PARAM$	_SYS_HEAT_MAP_SEG_HISTOGRAM
DBMS_AQ	ILM_RESULTS$

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	GET_NEXTN_OBJPOL	PREVIEW_ILM
CHECK_CONFLICT	GET_OBJPOLICY_STAT	PRINT_ADO_INFO
CREATE_JOBS_REBUILD_DEP	GET_OBJ_STAT	PRINT_ILMOBJ
CREATE_JOB_DEP	GET_POLICY_INFO	PRINT_OBJPOLICY_INFO
CREATE_TAB_ILMJOB	GET_STAT_TIME	PRINT_TAB_ADOJOB
DEPOBJ_STATE	GET_WEIGHT	PRINT_TAB_NUMBERS
DETERMINE_CONFLICT	HEAT_MAP_ON	PRINT_TAB_OBJPOLICY_INFO
DISABLE_TAB_OBJPOLICY	ILMJOBEXISTS	PRINT_TAB_OBJPOLICY_STAT
EVALUATE_ILM_POLICIES	ILM_AUTHORIZE	PRINT_TAB_RID
EXECUTE_ILM_POLICIES	ILM_CALLBACK	PRINT_TBS_STAT
EXECUTE_ILM_SCH	ILM_CLEANUP	PURGE_ILM
EXECUTE_TASK	ILM_CONSISTENCY	REMOVE_FROM_ILM
EXEC_ILM_ACTION	ILM_DICT_CLEANUP	SCHEDULE_COLSTATS_FLUSH
EXEC_ILM_ACTION_ICD	ILM_DICT_CLEANUP_CHECK	SCHEDULE_ROWMAPS_FLUSH
EXEC_ILM_ACTION_ROW	ILM_JOBCOMPLETION	SCHEDULE_SEGMENTS_FLUSH
FILTER_BY_WEIGHT	ILM_RESOLVETASKS	SETDEBUG
FILTER_FOR_MOVE	ILM_TASKCOMPLETE	STOPJOBS
GEN_EXECUTION_ID	INIT_ACT	STOPJOBS1
GEN_RID_RANGE	INIT_PNAME	STORE_VALID_INDEXES
GETENV	INSERT_TAB_ILMJOB	TRACE
GETSECTICK	INSERT_TAB_ILMTASKINFO_DDL	UPDATE_ILMEXECUTION
GET_EVALUATEDTASK_JOB_INFO	ISSUPLOGENABLED	UPDATE_JOB_STATUS
GET_EVAL_INFO	IS_FILTER_CANDIDATE	UPDATE_TAB_ILMJOB
GET_ILMOBJ_TAB	LOCK_ILM_DICT	VALIDATE_EXECID
GET_IMCMPLEVEL	POPULATE_GRP_DEP	VERIFY_PRECONDITION_POLICIES
GET_JOB_INFO	POPULATE_TBS_STAT	VERIFY_SUCCESS_POLICY
GET_NEXTN_OBJ

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

EXEC_ILM_ACTION_ICD

Undocumented prvt_ilm.exec_ilm_action_icd( act_code IN NUMBER) polname IN VARCHAR2, safeown IN VARCHAR2, safeobjname IN VARCHAR2, safesubobjname IN VARCHAR2, objtype IN NUMBER, execmode IN NUMBER, scope IN NUMBER, cmptype IN NUMBER, cmplvl IN NUMBER, flag IN NUMBER, tbs_name IN VARCHAR2, owner IN VARCHAR2, objname IN VARCHAR2, strvn IN NUMBER, stblk IN NUMBER, endrfn IN NUMBER, endblk IN NUMBER, objd IN NUMBER, colname IN VARCHAR2);

TBD

EXEC_ILM_ACTION_ROW

Undocumented prvt_ilm.exec_ilm_action_row( p_action IN sys.prvt_ilm.act_context, p_polctx IN sys.prvt_ilm.policy_context, p_execmode IN NUMBER, p_actresult IN OUT sys.prvt_ilm.act_result);

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

GETENV

Undocumented prvt_ilm.getenv(isatp IN OUT NUMBER);

DECLARE

       ioVal NUMBER := 42;

      BEGIN

        prvt_ilm.getenv(ioVal);

        dbms_output.put_line(ioVal);

      END;

      /

      0

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