Stats gather issue

Hey all,

Oracle 19c standalone

I have a developer who has created a table thats about 20G and has about 1500 to 1600 partitions and sub-partitions and 21 indexes. Stats gather fails on this table 99% of the time or takes days to complete.

Is there a good/better way to collect on this  or should he look at the design, i feel like 20G isnt that big but i feel like its all the partitions. Im not a developer so i dont know maybe this is normal

I tried

BEGIN dbms_stats.gather_table_stats(ownname=>'CAT', TABNAME=>'ORDER_SEARCH', estimate_percent => dbms_stats.AUTO_SAMPLE_SIZE, degree =>32, cascade=>true); END;