Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Permanent Tablespace for sorting.

RE: RE: Permanent Tablespace for sorting.

From: Amar Kumar Padhi <TS2017_at_emirates.com>
Date: Wed, 29 Aug 2001 00:09:44 -0700
Message-ID: <F001.0037AA66.20010829001619@fatcity.com>

Thanks Cris and Conner,
I was concerned about the performance implications between the two, even if minor.

rgds
amar

-----Original Message-----
From: Connor McDonald [mailto:hamcdc_at_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

Cheers
Connor

 --- dgoulet_at_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 <cspence_at_FuelSpot.com>
> 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
>
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
> Transitional//EN">
> <HTML><HEAD>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
> charset=us-ascii">
> <TITLE>Message</TITLE>
>
> <META content="MSHTML 5.50.4807.2300"
> name=GENERATOR></HEAD>
> <BODY>
> <DIV><SPAN class=040424112-28082001><FONT
> color=#0000ff size=2>No, it is
> generally better practice to use temporary
> tablespace for the following
> reasons.</FONT></SPAN></DIV>
> <DIV><SPAN class=040424112-28082001><FONT
> color=#0000ff
> size=2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=040424112-28082001><FONT
> color=#0000ff size=2>1.&nbsp; You will
>
> not accidentently store objects in
> it.</FONT></SPAN></DIV>
> <DIV><SPAN class=040424112-28082001><FONT
> color=#0000ff size=2>2.&nbsp; Reduced
> contention for the ST enqueue</FONT></SPAN></DIV>
> <DIV><SPAN class=040424112-28082001><FONT face=Arial
> color=#0000ff size=2>3.
> Reduce backup and recovery time</FONT></SPAN></DIV>
> <DIV><FONT face=Arial color=#0000ff
> size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face="Times New Roman">"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."</FONT></DIV>
> <P><FONT face=Script size=5>Christopher R.
> Spence</FONT> <BR><FONT
> face="Comic Sans MS" size=2>Oracle DBA</FONT>
> <BR><FONT face="Comic Sans MS"
> size=2>Phone: (978) 322-5744</FONT> <BR><FONT
> face="Comic Sans MS"
> size=2>Fax:&nbsp;&nbsp;&nbsp; (707) 885-2275</FONT>
> </P>
> <P><FONT face="Comic Sans MS" size=2>Fuelspot</FONT>
> <BR><FONT
> face="Comic Sans MS" size=2>73 Princeton
> Street</FONT> <BR><FONT
> face="Comic Sans MS" size=2>North, Chelmsford
> 01863</FONT> <BR><FONT
> face="Comic Sans MS" size=2></FONT>&nbsp; </P>
> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
>   <DIV></DIV>
>   <DIV class=OutlookMessageHeader lang=en-us dir=ltr

> align=left><FONT
>   face=Tahoma size=2>-----Original

> Message-----<BR><B>From:</B> Amar Kumar Padhi
>
>   [mailto:TS2017_at_emirates.com] <BR><B>Sent:</B>

> Tuesday, August 28, 2001 8:11
>   AM<BR><B>To:</B> Multiple recipients of list

> ORACLE-L<BR><B>Subject:</B>
>   Permanent Tablespace for sorting.

> <BR><BR></FONT></DIV><BR>
>   <P><FONT face=Courier size=2>Oracle recommends

> creation of separate temporary
>   tablespace for sort operations.&nbsp;

> </FONT><BR><FONT face=Courier size=2>Is
>   there any advantage in using a permanent

> tablespace instead of a temporary for
>
>   sort operations? </FONT></P>
>   <P><FONT face=Courier size=2>rgds</FONT> <BR><FONT

> face=Courier
>   size=2>amar</FONT> </P></BLOCKQUOTE></BODY></HTML>

>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
>   INET: dgoulet_at_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_at_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_at_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_at_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).
Received on Wed Aug 29 2001 - 02:09:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US