RE: Temporary Tablespaces

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 10 Jan 2005 10:24:58 -0500

Les, If the temp tablespace is created using tempfiles which are in turn
"re-created" every time the instance is started how is it that pmon has to
clean up a log of small extents each time the instance starts?  What
extents?

-- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hollis, Les
Sent: Sunday, January 09, 2005 2:27 PM
To: Bryan Wells; Oracle-L
Subject: RE: Temporary Tablespaces


1: create default temporary tablespace tspacename


CREATE TEMPORARY TABLESPACE temp
TEMPFILE '/u01/oradata/temp01.dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4M;  =20

(Set your uniform size to a reasonable size based on your database size.
DO NOT use small extents.  Use 5m, 10m, even up to 100m if your tspace
is large enough  If you set it too small, you run in to the iissue of
PMON running a long time to clean up the huge number of small extents
each time the instance starts.)


After tablespace is created,=20




ALTER DATABASE=20
DEFAULT TEMPORARY TABLESPACE temp;


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

Other related posts: