Do you know how to capture the sql_id for the statement in question? With this information, run a sql_id specific awr report from the command line. It should tell you the amount of temp estimated, the plan with totals for each step. This will tell you what is eating up temp, but please consider correcting the issue before just upping temp...:) From SQL Plus: SET LINESIZE 240 SET PAGESIZE 500 SELECT * FROM TABLE (DBMS_XPLAN. DISPLAY_AWR (<SQL ID>)); Let me know if you need more, Kellyn Pot'Vin @DBAKevlar Sent from Yahoo Mail on Android