Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: About TEMPFILE creation

Re: About TEMPFILE creation

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 9 Mar 2007 17:24:59 +0100
Message-ID: <45f18a5a$0$28802$426a74cc@news.free.fr>

"steven_nospam at Yahoo! Canada" <steven_nospam_at_yahoo.ca> a écrit dans le message de news: 1173456735.752097.70700_at_p10g2000cwp.googlegroups.com...
| System: AIX 5L
| RDBMS: Oracle 9i
|
| Is there any difference (advantage or disadvantage) to how you set up
| a temporary tablespace? In Oracle 8i, we always used datafiles for our
| temp tablespaces, such as the following:
|
|
| ##### OLD VERSION #######
| CREATE DATABASE databasename
| ...;
|
| CREATE TABLESPACE temptbspacename
| DATAFILE '/data/file/name'
| SIZE 300M
| AUTOEXTEND OFF
| ONLINE TEMPORARY;
|
| Starting with Oracle 9i, we started to create new databases with the
| temptbspace listed as part of the CREATE DATABASE statement.
|
| ##### NEW VERSION ######
| CREATE DATABASE databasename
| DATAFILE '/data/file/name' SIZE 512M
| DEFAULT TEMPORARY TABLESPACE temtbdspacename
| TEMPFILE '/temp/file/name'
| SIZE 300M
| AUTOEXTEND ON
| MAXSIZE 1000M.....;
|
| The only difference we have seen is that the temp tablespace is now
| listed in V$TEMPFILE instead of being in V$DATAFILE along with the
| other data files.
|
| So we have three questions:
|
| 1) Which is the more accepted practice for creating the temp
| tablespace?
|
| 2) Is anyone aware of any plans to change how temp tablespaces are
| created or maintained for future versions of Oracle (we have not
| checked this in 10g yet)
|
| 3) Is there any performance hit that may result from doing this one
| way or the other?
|
| Thanks in advance,
|
| SteveN
|

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96533/undo_temp.htm#18628
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96521/tspaces.htm#9566
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_74a.htm#2063374
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_75a.htm

Regards
Michel Cadot Received on Fri Mar 09 2007 - 10:24:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US