Oracle index fragmentation
Posted on 2015-01-13
my Oracle DB version is: Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production
I've 150 indexes with high fragmentation and now I'd like to remove or to reduce index fragmentation (Shrinking Indexes), but I need that this operation be done completely online.
Which SQL script I can use to reduce the index defragmentation?
Thanks in advance!