In 12c, Oracle introduced package to manage the global indexes orphan entry clean up and clearing up the online partition movement stuff. Here it is
PROCEDURE CLEANUP_GIDX- To clean up the global indexes , this runs daily at 2.00AM via scheduler job automatically PROCEDURE CLEANUP_GIDX_INTERNAL - To clean up the internal tables PROCEDURE CLEANUP_ONLINE_OP - To clean up the online partition movements SQL> desc dbms_part PROCEDURE CLEANUP_GIDX Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- SCHEMA_NAME_IN VARCHAR2 IN DEFAULT TABLE_NAME_IN VARCHAR2 IN DEFAULT PROCEDURE CLEANUP_GIDX_INTERNAL Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- SCHEMA_NAME_IN VARCHAR2 IN DEFAULT TABLE_NAME_IN VARCHAR2 IN DEFAULT ORPHANS_ONLY_IN NUMBER(38) IN DEFAULT NOOP_OKAY_IN NUMBER(38) IN DEFAULT PROCEDURE CLEANUP_ONLINE_OP Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- SCHEMA_NAME VARCHAR2 IN DEFAULT TABLE_NAME VARCHAR2 IN DEFAULT PARTITION_NAME VARCHAR2 IN DEFAULT SQL>
Follow Me!!!