dbms_stats - Suckes

[Chandra]

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

[pando]

degree 4, how many cpus do you have?

[Chandra]

i am sorry this my env.

Sun E 3500 - 4 x 400 MHz, 2 GB RAM, Solaris 8 and A5200 Storager sub system
Oracle 8.1.6.2

Thanks

[pando]

try degree 8