Home » RDBMS Server » Server Administration » Temp extents
Temp extents [message #63729] Tue, 02 November 2004 07:22 Go to next message
Craig
Messages: 28
Registered: October 2001
Junior Member
Guys

When I run a report we have here it blows the temp segments on it's tablespace rep_temp.  This is a temporary tablespace.  I have uped the sort_area_size as it does a hash join in the report but, it still blows this tablespace with an unable to extend temp_segment 50 in rep_temp.  I gave the tablespace a silly amount of space but, it just fills it up. Any ideas?

Many thanks for any help you can give.

Report message to a moderator

Re: Temp extents [message #63733 is a reply to message #63729] Tue, 02 November 2004 23:41 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

First of all tell us which version of oracle you are using and on which platform ??

Daljit Singh.

Report message to a moderator

Re: Temp extents [message #63735 is a reply to message #63733] Wed, 03 November 2004 00:27 Go to previous message
Craig
Messages: 28
Registered: October 2001
Junior Member
Version 9.2 - Linux 3.0es - Red Hat

Report message to a moderator

Previous Topic: SGA size
Next Topic: Extremely Urgent.Pleeeeeeeeeeeease
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:24:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.