Hi,

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???)

Regards,
Karthick R

Why does that matter? And how would you find that when you had statistics? And what is stopping you from gathering them anew?

Hi Steve,
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??

Regards,
Karthick R

'rule' is so deprecated, why you are using 'rule' optimiser_mode?
to your question,as you have not set CBO, table stats anyway do not matter.