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@(protected)]
On Behalf Of Prabhu, Krishnaswamy
Sent: Saturday, July 08, 2006 3:11 PM
To: oracle-l@(protected)
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