Home » Server Options » RAC & Failsafe » RAC & temp space allocation
RAC & temp space allocation [message #125557] Mon, 27 June 2005 10:22 Go to next message
hero
Messages: 5
Registered: May 2005
Junior Member
it seems that instance never frees allocated
sort segment (even the restart does not help).
the problem is that in multi instance
scenario one instance allocates all the temp space ( or
a large amount of it ) and it stays allocated for ever.

Is it possible to limit the amount of temp space
a single instance can allocate ? how do you solve this
problem ?

Report message to a moderator

Re: RAC & temp space allocation [message #125845 is a reply to message #125557] Wed, 29 June 2005 08:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post your Oracle version and OS versions.
This might be a bug.
Please crosscheck whether this concerned tablespace is been created with 'default' clause.
If so, please ***Test*** this in your ***test environment*** and let us know.
recreate the temp tablespace as a normal temporary tablespace ( without the default option).
try again.

Report message to a moderator

Re: RAC & temp space allocation [message #128892 is a reply to message #125845] Thu, 21 July 2005 02:07 Go to previous message
hero
Messages: 5
Registered: May 2005
Junior Member
thanks for the suggestion, it seems that the non-default temp works differently. we have found out that the default temp
works OK as well ( the instance is able to claim the needed space from the other instance when necessary )

[Updated on: Thu, 21 July 2005 02:08]

Report message to a moderator

Previous Topic: Oracle RAC Failover
Next Topic: RAC shutdowns when public network is down ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Oct 12 19:18:51 CDT 2026
.:: Forum Home :: Wiki Home :: Contact :: Privacy ::.