Home » RDBMS Server » Performance Tuning » temp segment error
temp segment error [message #148054] Tue, 22 November 2005 08:26 Go to next message
imrajan78
Messages: 5
Registered: October 2005
Location: Chennai
Junior Member

Hi friends ,

still i didnot find the solution of the below error. We are running a ( through oracle warehouse builder) automatic created by owb when we start run the query we are getting the error called "unable to extend temp segment by 128 mb in temp file"
what is the solution of that.

we have 13gb temp file size.
Please urgent
Govindarajan
Re: temp segment error [message #148057 is a reply to message #148054] Tue, 22 November 2005 08:35 Go to previous messageGo to next message
rucknrun
Messages: 26
Registered: April 2005
Location: Edgewood, MD
Junior Member
Are you doing a large sort on the query? You may need increase the sort_area_size so not as much of the sorting is written to disk.
Re: temp segment error [message #149190 is a reply to message #148054] Wed, 30 November 2005 08:37 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
yep, you are running out of room in temp file. BUT, is your extent size of your temp tablespace really 128 MEGS?? That should be much, much lower. I would guess you are wasting lots of space with internal fragmentation due to such a large size.
Previous Topic: Multi-Insert in Parallel
Next Topic: Incorrect system statistics
Goto Forum:
  


Current Time: Thu Mar 28 15:50:03 CDT 2024