Message

From TS2017@emirates.com Wed, 29 Aug 2001 00:07:47 -0700 From: Amar Kumar Padhi Date: Wed, 29 Aug 2001 00:07:47 -0700 Subject: RE: RE: Permanent Tablespace for sorting. Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: RE: Permanent Tablespace for sorting. How do we check on the ST enqueue contention? rgds amar -----Original Message----- From: Connor McDonald [mailto:hamcdc@yahoo.co.uk] Sent: Tuesday, August 28, 2001 10:33 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Permanent Tablespace for sorting. I suppose the response to this would be "why bother?". temp tablespaces (especially tempfile ones) will have - less impact on redo logs - allows current ( or future) use of standby for read-only - no need for any "offline drop" etc Cheers Connor --- 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 > > > Transitional//EN"> > > > Message > > name=GENERATOR> > >

color=#0000ff size=2>No, it is > generally better practice to use temporary > tablespace for the following > reasons.

color=#0000ff > size=2>

color=#0000ff size=2>1. You will > > not accidentently store objects in > it.

color=#0000ff size=2>2. Reduced > contention for the ST enqueue

color=#0000ff size=2>3. > Reduce backup and recovery time

size=2>

"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
face="Comic Sans MS" > 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>

>
>
align=left>   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
face=Courier >   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). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc@yahoo.co.uk 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).