Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RAC and undo tablespace

Re: RAC and undo tablespace

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 09 Mar 2006 03:04:48 GMT
Message-ID: <pan.2006.03.09.03.04.47.304358@sbcglobal.net>


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.com
Received on Wed Mar 08 2006 - 21:04:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US