I have two partionned table with both 50 partitions and 30 000 000 records.

I use this command to gather stats :

Alter session set sort_area_size=100000000;

dbms_stats.gather_schema_stats(ownname=>'&&1', estimate_percent=>5 , method_opt=>'FOR ALL COLUMNS SIZE SKEWONLY', degree=>3, granularity=>'ALL', cascade=>TRUE);

The time spent is very high on partionned tables.

Please advise for improve perfomance.

Thanks for advance.