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 ?



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: 10694
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.

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:
  


Current Time: Wed Oct 20 08:08:22 CDT 2021