| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Permanent Tablespace for sorting.
No, it is
generally better practice to use temporary tablespace for the following
reasons.
<FONT color=#0000ff
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 <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" size=2>Phone: (978) 322-5744 <FONT face="Comic Sans MS" size=2>Fax: (707) 885-2275
face="Comic Sans MS" size=2>73 Princeton Street <FONT face="Comic Sans MS" size=2>North, Chelmsford 01863 <FONT face="Comic Sans MS" size=2>
<FONT
face=Tahoma size=2>-----Original Message-----From: Amar Kumar Padhi
[mailto:TS2017_at_emirates.com] Sent: Tuesday, August 28, 2001 8:11
AMTo: Multiple recipients of list ORACLE-LSubject:
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 <FONT face=Courier
size=2>amar
Received on Tue Aug 28 2001 - 08:26:39 CDT
 |
 |