Help - Search - Members - Calendar
Full Version: Fragmentation
Oracle DBA Forums > Oracle > Oracle Forum
karthickr
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
SteveC
Why does that matter? And how would you find that when you had statistics? And what is stopping you from gathering them anew?
karthickr
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



QUOTE (karthickr @ Jun 26 2008, 03:10 PM) *
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
suresh_oradba
'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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.