Re: How to estimate TEMP usage for DBMS_STATS?
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 18 Feb 2010 07:45:29 -0800 (PST)
Message-ID: <770614.78149.qm_at_web80607.mail.mud.yahoo.com>
Rich,
Date: Thu, 18 Feb 2010 07:45:29 -0800 (PST)
Message-ID: <770614.78149.qm_at_web80607.mail.mud.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 18 2010 - 09:45:29 CST