Estimate required temporary space

Dear community,

I would like to open a new discussion to know if you can help me, I really appreciate your time.

I am trying to estimate the required temporary space to running gather_table_stats for a long table ( 311MM rows, 300GB ) but it runs out of temporary space:

exec dbms_stats.gather_table_stats(ownname => 'OWNER', tabname=> 'TNAME', cascade=>true, estimate_percent=>50, method_opt=>'for all columns size repeat',degree=>DBMS_STATS.AUTO_DEGREE);

I've followed the following steps:

• Enable trace level: exec dbms_stats.set_param('trace','3294');
• Identify sql wich runs out of temporary space: