Before i used to find the fragmentation from empty_blocks from user_tables . Now i changed my database optimizer mode to rule and I deleted statistics for all the tables...
My questions is.
1.How to find the table fragmentation ??
2.As the optimizer mode is RULE and if i collect the statistics for all tables It will affect performance??
QUOTE (karthickr @ Jun 26 2008, 03:10 PM)
My database optimizer_mode is RULE and i deleted statistics for all the tables .How can i find the
fragmention ??(only with number of extents???)