What are u seeing to make you believe that you need separate temp segements per instance?
Murali Vallath
Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 20 Mar 2003 17:14:18 -0800
Is there a way in RAC that I can create 2 TEMP tablespaces which can be explicitly assigned to separate instances of RAC. Or is there a way that to specify the size of the instance-specific temp segments? If I have a TEMP tablespace with a size of 10GB, how can i split it between 2 instances with 5GB each. We're using 9.2.0.2.
Are there any white papers that talk about how TEMP is managed in RAC?
As I understand it, if you have a single TEMP tablespace, there will be 2 temp segments created under the TEMP tablespace specific to each instance and extents will be allocated from those segments to each instance's session, but Oracle doesn't allow for TEMP space to be pre-allocated between instances. Depending on the instance-specific TEMP segment's requirements, it allocates and deallocates automatically between segments.
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murali Vallath INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
