From dgoulet@vicr.com Tue, 28 Aug 2001 05:58:40 -0700 From: dgoulet@vicr.com Date: Tue, 28 Aug 2001 05:58:40 -0700 Subject: Re:RE: Permanent Tablespace for sorting. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Chris, I've always used a permanent tablespace for temp and have not had the problems you state. But it does take some consistency to maintain. 1- we never allow anyone a quota on temp or even allow anyone to have that as their default. Come to think of it only sys has system as it's default tablespace. We also do not allow 'unlimited tablespace' even to purchased apps. 2- The ST enqueue has not been a problem, actually have 0 contention there even in the data warehouse. 3- we don't back it up. Have had one get trashed, along with the disk drive. Did an offline drop and rebuilt it elsewhere. Dick Goulet ____________________Reply Separator____________________ Author: Christopher Spence Date: 8/28/2001 5:50 AM No, it is generally better practice to use temporary tablespace for the following reasons. 1. You will not accidentently store objects in it. 2. Reduced contention for the ST enqueue 3. Reduce backup and recovery time "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -----Original Message----- Sent: Tuesday, August 28, 2001 8:11 AM To: Multiple recipients of list ORACLE-L Oracle recommends creation of separate temporary tablespace for sort operations. Is there any advantage in using a permanent tablespace instead of a temporary for sort operations? rgds amar Message
No, it is generally better practice to use temporary tablespace for the following reasons.
 
1.  You will not accidentently store objects in it.
2.  Reduced contention for the ST enqueue
3. Reduce backup and recovery time
 
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:    (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 

-----Original Message-----
From: Amar Kumar Padhi [mailto:TS2017@emirates.com]
Sent: Tuesday, August 28, 2001 8:11 AM
To: Multiple recipients of list ORACLE-L
Subject: Permanent Tablespace for sorting.


Oracle recommends creation of separate temporary tablespace for sort operations. 
Is there any advantage in using a permanent tablespace instead of a temporary for sort operations?

rgds
amar

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).