I tryed to analyze the partition table by using the
dbms_stats, after 24 hours also it is still running then i killed
that job. when i use the analyze it usualley take 6 hours/partition. i got app. 300 million rows in every partition.
Any suggestions...........
Here is the script i used:
DECLARE
BEGIN
dbms_stats.gather_table_stats(
ownname => 'SAM',
tabname => 'mess_count',
partname => 'apr02',
estimate_percent => null,
block_sample => false,
method_opt => 'FOR ALL COLUMNS SIZE 1',
degree => 4,
granularity => 'default',
cascade => true,
stattab => null,
statid => null,
statown => null);
END;
/

Thanks