All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

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>

Comments are closed.