OraFAQ Forum: RAC & Failsafe » RAC & temp space allocation

Home » Server Options » RAC & Failsafe » RAC & temp space allocation

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

RAC & temp space allocation [message #125557]

Mon, 27 June 2005 10:22

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 05 08:09:07 CST 2025