This content has been marked as final. Show 4 replies
Provided you are using Locally Managed Tablespaces:
Why are you still subscribing to Ye Olde Fragmentation Myth?
Using LMT, objects won't get fragmented, EVER.
Ye Olde Fragmentation Myth has been invented by consultants to keep their income high: they come over to de-fragment your database every few months, and this doesn't resolve anything.
Senior Oracle DBA