| running out of TEMP space [message #635531] |
Tue, 31 March 2015 11:06  |
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  |
gazzag
Messages: 1119
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
