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: 389
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: 1118
Registered: November 2010
Location: Bedwas, 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: Thu Mar 28 20:33:40 CDT 2024