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
this will helps you to understand fragmentation.
You aren't on a pre-8i database version, are you?
Thank you, for your help.
You're right I have LMT objects in Oracle 9i, but I have others databases in olders version, like....Oracle 7.
In Oracle 7 I think there is fragmentation.
Do you know any script or query to check the level of fragmentation???
Thanks in advance