From joan.hsieh@tufts.edu Thu, 30 Aug 2001 11:31:20 -0700 From: Joan Hsieh Date: Thu, 30 Aug 2001 11:31:20 -0700 Subject: Re: Permanent Tablespace for sorting. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Dick, Just wondering why not just convert it to temp tablespace? Joan Hsieh DBA -ocp 7&8 617-627-5032 dgoulet@vicr.com wrote: > > 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.
>
size=2> 
>
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
face="Comic Sans MS" size=2>Oracle DBA
size=2>Phone: (978) 322-5744
size=2>Fax:    (707) 885-2275

>

Fuelspot
face="Comic Sans MS" size=2>73 Princeton Street
face="Comic Sans MS" size=2>North, Chelmsford 01863
face="Comic Sans MS" size=2> 

>
>
>
face=Tahoma size=2>-----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
size=2>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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: joan.hsieh@tufts.edu 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).