Home » RDBMS Server » Server Administration » running out of TEMP space (11.2.0.4)
running out of TEMP space [message #635531] Tue, 31 March 2015 11:06 Go to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
Hi Experts,

I am getting the error ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
while running a dml statement. I increased the TEMP size by 60g and get rid of the error.
But now when developers try to run the batch, they are getting the same error.
I have following question:-

Do I need to keep adding more temp space or it could be related to some different underlying issue?

Thanks,

Varun
Re: running out of TEMP space [message #635532 is a reply to message #635531] Tue, 31 March 2015 11:12 Go to previous message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
60GB is a heck of a lot for a temporary tablespace.
Quote:

it could be related to some different underlying issue?

Yes. There is something in that batch run that is wrong/inefficient. You should analyse the constituent SQL statements. A symptom like this has cartesian join stamped all over it.
Previous Topic: How to upgrade time zone binaries
Next Topic: Index Organized Table
Goto Forum:
  


Current Time: Tue Jan 16 20:18:27 CST 2018

Total time taken to generate the page: 0.05875 seconds