First analyze if an index segment requires rebuild because its resource intensive process. ANALYZE INDEX {index name} VALIDATE STRUCTURE; SQL> SELECT name, height, lf_rows, lf_blks, del_lf_row FROM INDEX_STATS; Then Rebuild index only if you see HEIGHT is above 4 and Deleted Leaf Row is less than 20. ALTER INDEX {index name} REBUILD ONLINE;