Home » RDBMS Server » Performance Tuning » Running out of 64gb Temp Space (12c)
Running out of 64gb Temp Space [message #667042] Tue, 05 December 2017 14:47 Go to next message
dbogey
Messages: 1
Registered: December 2017
Junior Member
We've been running into some issues with a query that is taking up over 64bg of temp space. We've been told to continue to add more temp space to ensure the query runs to completion. I've attached the explain plan from TOAD. Any help or insight would be of help.
  • Attachment: ORA_FAQ.txt
    (Size: 45.01KB, Downloaded 17 times)
Re: Running out of 64gb Temp Space [message #667043 is a reply to message #667042] Tue, 05 December 2017 15:01 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Since NOBODY can optimize SQL just by looking at it, we need a few more details.
http://www.orafaq.com/forum/mv/msg/84315/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof

Re: Running out of 64gb Temp Space [message #667044 is a reply to message #667043] Tue, 05 December 2017 15:05 Go to previous message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
EXPLAIN PLAN FOR <"slow" SQL statement>
SELECT * FROM table(dbms_xplan.display);

do as above
Previous Topic: Session Trace file Location - Oracle 12c
Next Topic: DB Health checks
Goto Forum:
  


Current Time: Sun Dec 17 11:28:20 CST 2017

Total time taken to generate the page: 0.02385 seconds