Re: Temporary tablespace usage
- From: "kellyn.potvin@xxxxxxxxx" <kellyn.potvin@xxxxxxxxx>
- To: "oratune@xxxxxxxxx" <oratune@xxxxxxxxx>, "mcunningham@xxxxxxxxxxxxxx" <mcunningham@xxxxxxxxxxxxxx>, "peter.schauss@xxxxxxx" <peter.schauss@xxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Mar 2014 19:11:55 -0700 (PDT)
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
Other related posts:
