RE: Using multiple Temp tablespaces
- From: "ramick" <ramick@xxxxxxxxxxx>
- To: <prabhu_adam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 8 Jul 2006 15:23:41 -0700
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Prabhu, Krishnaswamy
Sent: Saturday, July 08, 2006 3:11 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
