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)
Rich,
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
