Why do 2 diff. undo tablespace required in RAC
LyxxSep 2 2008 — edited Sep 11 2008Hi -
1 - I can understand that we do require 2 diff. log files as 2 process can not write on the same redo log files.
But I could not understand the logic of using 2 diff. undo tablespaces, when tablespaces can be in shared mode.
They what is the reason of using 2, why can we not have only one undo tablespace in RAC.
2 - Is there any way to check if one particular instance is running under RAC, Can this be confirmed if instance
has got extra process like Lms Lmd ...
your help would be appreciated and apologies for my poor english.
Regards,
Lyxx