OraFAQ Forum: Server Administration » temp tablespace question

Home » RDBMS Server » Server Administration » temp tablespace question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

temp tablespace question [message #177568]

Thu, 15 June 2006 09:08

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

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

Mahesh Rajendran
Messages: 10708
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 15 09:56:35 CST 2026