wagen123_at_yahoo.com wrote:
>> Each instance can only use one undo tablespace at a time.
>> Instances cannot share undo tablespaces.
> WHY? If two instances in a two node RAC cluster can share a temp
> tablespace why not an undo tablespace?
>
> Thanks for your input.
In theory they could have but that is not the way Oracle designed it.
As to why this specific design decision was made I can't say. Likely
it has to do with the same reason that when performing a backup ...
one gneerally backs up UNDO but not TEMP. Temp is expendable.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Mar 08 2006 - 15:02:59 CST
