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

Home -> Community -> Mailing Lists -> Oracle-L -> Temporary Tablespace and RAC

Temporary Tablespace and RAC

From: Balakrishnan, Ashok - VSCM <Balakrishnan.Ashok_at_vectorscm.com>
Date: Thu, 20 Mar 2003 17:12:46 -0800
Message-Id: <24726.322601@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2EF46.FB987E2F
Content-Type: text/plain;

        charset="iso-8859-1"

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.        

------_=_NextPart_001_01C2EF46.FB987E2F
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana size=2>Is there a way in
RAC that I can create 2 TEMP tablespaces which can be explicitly assigned to separate instances of RAC.&nbsp;Or is there a way that&nbsp;to specify the size of the instance-specific&nbsp;temp segments?&nbsp;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.</FONT></SPAN></DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana size=2>Are there any
white papers that talk about how TEMP is managed in RAC?</FONT></SPAN></DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana size=2>As I understand
it, if you have a single TEMP tablespace, there&nbsp;will be&nbsp;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&nbsp;to be pre-allocated between instances. Depending on the instance-specific TEMP segment's requirements, it allocates and deallocates automatically between segments.</FONT></SPAN></DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=267153400-21032003><FONT face=Verdana
size=2></FONT></SPAN>&nbsp;</DIV></BODY></HTML> Received on Thu Mar 20 2003 - 19:12:46 CST

Original text of this message

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