Re: How to estimate TEMP usage for DBMS_STATS?


Why not alter session enable resumable and check dba_resumable once in 
a while? Or wait till alert.log tells you it's waiting for temp space.

If you really want to estimate, I think it's possible to SQL trace the 
dbms_stats execution to identify the exact SQL that needs temp. Then 
explain plan for the SQL. The TEMP SPACE column of the explain plan 
output gives you the estimated temp space.

Yong Huang


Other related posts: