Index Archive

Oracle 12c: Global Index maintenance is now asynchronous

Introduction Maintaining global indexes were always a expensive task in Oracle, particularly in the context of partitioned tables, where dropping or truncating a table partition could cause a global index to become UNUSABLE/INVALID unless specified to update

Query to monitor progress of Index creation or Index rebuild

The following query can be used to monitor the progress of Index creation or Index rebuild for huge indexes. ------------------------------------- ---- Script: chk_idx_progress.sql ---- Author: Abu Fazal Mohammed Abbas -------------------------------------- set lines 200 col "Index Operation" for
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed