RE: Using multiple Temp tablespaces

From: ramick <ramick_at_dotster.com>
Date: Sat, 8 Jul 2006 15:23:41 -0700
Message-Id: <20060708222348.9EC2039492C@turing.freelists.org>

How many files do you have in your current temporary tablespace?

See Bug No. 2858082 - this is supposed to be fixed in 9207 & 10201+, but you might want to make sure.

Also, please see Oracle Note:258941.1 - RAC databases and ORA-1652: Unable To Extend Temp Segment By %s In Tablespace TEMP This as well as it's referances should give you a good understanding of how RAC uses temp segments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Prabhu, Krishnaswamy
Sent: Saturday, July 08, 2006 3:11 PM
To: oracle-l_at_freelists.org
Subject: Using multiple Temp tablespaces

Hi List,

Currently we are using only one temporary tablespace for all three node RAC database (9207). We are planning to create additonal temporary tablespaces. In this
regard, I would like know if there are any issues/concerns using additional tempoary tablespaces in a three node 9207 RAC system. Please advice.

Thanks,
Prabhu

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Sat Jul 08 2006 - 17:23:41 CDT