Script to find fragmented tables in Oracle 10g
Please let me know how do I findout the tables which are fragmented in oracle 10g...
Note : Considering business needs, we can not gather the table STATS..
Is there any way to findout the fragmented tables in a schema without collecting STATS using Analyze stmt or DBMS_STATS package.
Your help is much appreciated.
Thanks,
Riaz