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@xxxxxxxx] 
Sent: Tuesday, September 28, 2004 2:00 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Rivaldi Bahar
Sent: Tuesday, September 28, 2004 1:02 AM
To: oracle-l@xxxxxxxxxxxxx
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.



---------------------------------
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: