RE: Using multiple Temp tablespaces
- From: "ramick" <ramick@xxxxxxxxxxx>
- To: "'Prabhu, Krishnaswamy'" <prabhu_adam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 8 Jul 2006 18:17:38 -0700
Check which files are owned by which instance. I think this depends upon
startup times of the instances - sort of like the old rollback segments
where each instance will try to online any segment it can during startup.
Someone please correct me if this is wrong.
If all nodes are active during the use of current temp space, I would lean
towards evenly distributing the temp files so there is the least amount of
borrowing going on.
I would also monitor the use of these segments during use.
May I ask why you intend to create additional temporary tablespaces?
-----Original Message-----
From: Prabhu, Krishnaswamy [mailto:prabhu_adam@xxxxxxxxxxx]
Sent: Saturday, July 08, 2006 5:12 PM
To: ramick@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Using multiple Temp tablespaces
Many Thanks Ramick.
Its a datawarehouse environment, our current temporary tablespace size is
250 gig. Ten tempfiles are there, each 25 gig in size.
Thanks,
Prabhu
>From: "ramick" <ramick@xxxxxxxxxxx>
>Reply-To: ramick@xxxxxxxxxxx
>To: <prabhu_adam@xxxxxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
>Subject: RE: Using multiple Temp tablespaces
>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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
