Subscriber Count

    466

Subscribe to Posts by Email

Pages

12c Database : New DBMS_PART package to cleanup the partition maintenance activities

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>

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>