Re: How to estimate TEMP usage for DBMS_STATS?

  • From: Yong Huang <yong321@xxxxxxxxx>
  • To: rjoralist@xxxxxxxxxxxxxxxxxxxxx
  • Date: Thu, 18 Feb 2010 07:45:29 -0800 (PST)


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: