From joan.hsieh@tufts.edu Fri, 31 Aug 2001 06:27:26 -0700 From: Joan Hsieh Date: Fri, 31 Aug 2001 06:27:26 -0700 Subject: Re: Permanent Tablespace for sorting. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Ha, I got you. You have too many boss. (what a pain) But I agree what you said in general. Joan H DBA -ocp 7&8 617-627-5032 dgoulet@vicr.com wrote: > > Joan, > > 1) because I've not had any problems using a permanent tablespace > 2) I'm an old timer set in my ways > 3) my sa is against it for disk fragmentation reasons > 4) my boss see's no reason to change something that is working without a > problem. > > In general, "if it ain't Baroque don't fix it". > > Dick Goulet > > ____________________Reply Separator____________________ > Author: Joan Hsieh > Date: 8/30/2001 10:59 AM > > 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. 
size=2>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). > -- > 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).