Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index Coalesced - How to verify this information?

DBA112Apr 22 2012 — edited Apr 22 2012

Hello All,

Can you please help me with this info:

I'm Coalescing indexes in a schema in our database. I know this merges the leaf blocks and removes fragmentation but doesn't reclaim space as in case of Index rebuild.

I want to know if there's a way to verify/ confirm that a particular Index is successfully coalesced?? I don't see any change OF VALUES IN - LEAF_BLOCKS, AVG_LEAF_BLOCKS_PER_KEY, CLUSTERING_FACTOR, SAMPLE_SIZE, LAST_ANALYZED from dba_indexes. I believe there must be some dictionary view which populates this kind of information. Please share your thoughts/ knowledge.

Thanks a lot
Shanthan

This post has been answered by user503699 on Apr 22 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2012

Added on Apr 22 2012

#general-database-discussions

4 comments

647 views