Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RAC and undo tablespace
On Wed, 08 Mar 2006 13:31:28 -0800, wagen123 wrote:
>
> Just curious to know why (technical reasons), that's all.
Probably to avoid locking themselves to death. Tablespaces which are mostly read aren't a problem. Tablespaces to which you write are a problem. Although that isn't strictly required any more, functional partitioning still helps. Having different users, log in from different instances and use different temporary tablespaces is better then having everybody logging in from just about any node. However advanced DLM is, however good things will get with dynamic remastering, it's still a significant overhead which should be avoided if possible.
-- http://www.mgogala.comReceived on Wed Mar 08 2006 - 21:04:48 CST