OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » temp tablespace

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

temp tablespace [message #55098]

Thu, 02 January 2003 21:40

Sunil Rohit
Messages: 2
Registered: January 2003

Junior Member

Sir,

Thanks for the help. I have gone thr' the same procedure and it helps a lot
to me and at last i have solved this problem.

In connection with this i would like to know following :
1) Which operations will make temp tablespace full ?
2) My archivelog mode is off, does it effect temp tablespace to become
full ?
3) How to restrict temp tablespace growth?, because after every month
or say quarter it is not abvisible to delete & recreate temp
tablespace.

Expecting your views on this.

Regards,
Sunil Rohit.

Report message to a moderator

Re: temp tablespace [message #55102 is a reply to message #55098]

Fri, 03 January 2003 04:04

sai sreenivas jeedigunta
Messages: 370
Registered: November 2001

Senior Member

hi,
Temp tablespace is generally used for doing sorting operations etc... i think i dont mind to recreate /do some excercise on temp once in a quarter :)

sai

Report message to a moderator

Re: temp tablespace [message #55104 is a reply to message #55102]

Fri, 03 January 2003 06:33

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

ethically,
you need to do nothing.
all sorting operations are done in temp tablespace.
It has nothing to do with ARCHIVELOG MODE.
Just toggle the datbase.
restarting the database releases the temp segments.
if you dont want to restart,
issue

ALTER TABLESPACE TEMP COALESCE;

Report message to a moderator

Re: temp tablespace [message #55107 is a reply to message #55102]

Fri, 03 January 2003 09:49

Sanjay
Messages: 236
Registered: July 2000

Senior Member

You will use the TEMP tablespace if the SORT_AREA_SIZE is small for the sort to be done in memory.

No, Archive Mode has nothing to do with the TEMP tablespace.

If the TEMP is full, you can either restart the database (if you can) to reset the tablespace or give this command

'alter tablespace temp default storage (pctincrease 0);'

It works.

Report message to a moderator

Previous Topic:	Regarding Personal oracle
Next Topic:	Oracle Universal Installer exits when next button is pressed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 06:24:40 CST 2024