Home » RDBMS Server » Server Administration » temp tablespace question
temp tablespace question [message #177568] Thu, 15 June 2006 09:08 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member
All,
I am reveiwing a database for a client, 9i
the temp tablespace has been set up as follows

create temporary tablespace temp
tempfile '/xxxx/xxxx.dbf' size 4700M reuse
autoextend on next 100M maxsize unlimited
extent management local uniform size 1M.

Is the uniform size of 1M okay, I have seen other creation scripts with a lot larger uniform size being specified

regs

Alan

Report message to a moderator

Re: temp tablespace question [message #182016 is a reply to message #177568] Wed, 12 July 2006 10:29 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
I do not see a problem with that. Are you getting an error?

Report message to a moderator

Re: temp tablespace question [message #182034 is a reply to message #182016] Wed, 12 July 2006 12:03 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> autoextend on
I would worry about that.
Temp space is re-used. No need to have autoextend on for temp space (actually, even for a permanent tablespace. I do not like surprises in production databases. Rather, i would monitor the tablespace usage closely).
A simple rogue query can eat up all the temp space. At somepoint, server will experience a full disk.

Report message to a moderator

Previous Topic: raw device and oracle connect with listener
Next Topic: Is there possible to see information from blocks, stored in buffer cache from C program???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:32:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.