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!

coalesce and shrink alter index decision

Muthu_BecomingDBAFeb 6 2016 — edited Feb 7 2016

Hi,

I just wanted to know, do we have any command with thumb of rule / threshold, when to consider coalesce and shrink. Like for rebuild blevel > 3%.

Thanks.

This post has been answered by AndrewSayer on Feb 7 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2016

Added on Feb 6 2016

#general-database-discussions

10 comments

1,790 views