OraFAQ Forum: Performance Tuning » Running out of 64gb Temp Space

Home » RDBMS Server » Performance Tuning » Running out of 64gb Temp Space (12c)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running out of 64gb Temp Space [message #667042]

Tue, 05 December 2017 14:47

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 709 times)

Report message to a moderator

Re: Running out of 64gb Temp Space [message #667043 is a reply to message #667042]

Tue, 05 December 2017 15:01

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Running out of 64gb Temp Space [message #667044 is a reply to message #667043]

Tue, 05 December 2017 15:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

EXPLAIN PLAN FOR <"slow" SQL statement>
SELECT * FROM table(dbms_xplan.display);

do as above

Report message to a moderator

Previous Topic:	Session Trace file Location - Oracle 12c
Next Topic:	DB Health checks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 01 10:44:53 CST 2023