Re[2]: Permanent Tablespace for sorting.

From: <dgoulet_at_vicr.com>
Date: Thu, 30 Aug 2001 13:10:17 -0700
Message-ID: <F001.0037E11D.20010830125621@fatcity.com>

Joan,

because I've not had any problems using a permanent tablespace
I'm an old timer set in my ways
my sa is against it for disk fragmentation reasons
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 <joan.hsieh_at_tufts.edu>
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_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> </DIV>
> <DIV><SPAN class=040424112-28082001><FONT color=#0000ff size=2>1.  You
will
>
> not accidentently store objects in it.</FONT></SPAN></DIV>
> <DIV><SPAN class=040424112-28082001><FONT color=#0000ff size=2>2. 
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> </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:    (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>  </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.  </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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joan Hsieh
  INET: joan.hsieh_at_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_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).
-- 
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).

Received on Thu Aug 30 2001 - 15:10:17 CDT