Today, I want to write about how to execute Backup & Recovery in Zero Data Loss Recovery Appliance 23 (ZDLRA 23) , an integrated Oracle solution for Backup & Recovery . press ZDLRA to read the content #Oracle #ZDLRA #Backup_Recovery

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;