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
- 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_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).
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