Re: Temporary tablespace usage
From: <kellyn.potvin_at_ymail.com>
Date: Wed, 26 Mar 2014 19:11:55 -0700 (PDT)
Message-ID: <1395886315.64894.YahooMailAndroidMobile_at_web162502.mail.bf1.yahoo.com>
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 _at_DBAKevlar Sent from Yahoo Mail on Android
Date: Wed, 26 Mar 2014 19:11:55 -0700 (PDT)
Message-ID: <1395886315.64894.YahooMailAndroidMobile_at_web162502.mail.bf1.yahoo.com>
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 _at_DBAKevlar Sent from Yahoo Mail on Android
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 27 2014 - 03:11:55 CET