| 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: Temp segment Pctincrease 1
Rivaldi,
I agree with everything Mark said. But to answer your question, there is no equivalent command because TEMP tablespaces are now untouchable by us mere DBA mortals.
Create a TEMP tablespace type 'temporary' as Mark said. Make it big enough for your system and then forget about it.
CREATE
TEMPORARY TABLESPACE TEMP TEMPFILE '/dba/u0004/UIBP/temp/temp_01.dbf'
SIZE 1000M REUSE
AUTOEXTEND ON NEXT 100M MAXSIZE 1000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;
Good Luck!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Mark W. Farnham [mailto:mwf_at_rsiz.com]
Sent: Tuesday, September 28, 2004 2:00 AM
To: oracle-l_at_freelists.org
Subject: RE: Temp segment Pctincrease 1
On the grounds that 1) overloading pctincrease as a signal to automated coalescence is one of the greatest errors ever made in Oracle's implementation history (second only to equating the zero length string and NULL in my opinion); 2) Coalescence of temp is a bad idea, since it should be configured uniformly so that complete free space fragmentation is the fastest way to give segments to sessions; 3) Yas outta be using one of the newer types of temporary tablespace storage, rather than answering your question I'll urge you to change your strategy.
In the case of an existing temp that is all messed up, make a good new one, alter everyone using the bad on to use the new one, and just get rid of that bad one.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Rivaldi Bahar
Sent: Tuesday, September 28, 2004 1:02 AM
To: oracle-l_at_freelists.org
Subject: Temp segment Pctincrease 1
What is the similar statement for 'alter tablespace temp default storage (pctincrease 1)' for Oracke 9.2 ?
It worked for Oracle 8.1 to coalesce temporary tablespace.
Thanks.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 28 2004 - 06:59:13 CDT
 |
 |