OraFAQ Forum: Performance Tuning » temp segment error

Home » RDBMS Server » Performance Tuning » temp segment error

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

temp segment error [message #148054]

Tue, 22 November 2005 08:26

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

Report message to a moderator

Re: temp segment error [message #148057 is a reply to message #148054]

Tue, 22 November 2005 08:35

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.

Report message to a moderator

Re: temp segment error [message #149190 is a reply to message #148054]

Wed, 30 November 2005 08:37

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.

Report message to a moderator

Previous Topic:	Multi-Insert in Parallel
Next Topic:	Incorrect system statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:58:34 CST 2024