OraFAQ Forum: Server Administration » clear TEMP Tablesapce

Home » RDBMS Server » Server Administration » clear TEMP Tablesapce

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

clear TEMP Tablesapce [message #54204]

Mon, 04 November 2002 19:25

Aor
Messages: 2
Registered: September 2002

Junior Member

Hello.
I use Ora9i and beginner.
How do you can clear TEMP Tablespace?
What's TEMP Tablespace?

Report message to a moderator

Re: clear TEMP Tablesapce [message #54213 is a reply to message #54204]

Tue, 05 November 2002 05:12

siddhu
Messages: 3
Registered: November 2002

Junior Member

Just drop he temp and recreate, but why the hell do u need to do that for ????

Report message to a moderator

Re: clear TEMP Tablesapce [message #54220 is a reply to message #54204]

Tue, 05 November 2002 10:33

Trifon Anguelov
Messages: 514
Registered: June 2002

Senior Member

If your tablespace is of type TEMPORARY (select CONTENTS from dba_tablespaces; - should give you TEMPORARY for TEMP tablespace), then the SMON background process will do that for you after the users finished using this tablespace.

To clear the UGA memory size, use SORT_AREA_RETAINED_SIZE. It does specifies in bytes the maximum amount of the user global area (UGA) memory retained after a sort run completes.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: clear TEMP Tablesapce [message #54248 is a reply to message #54204]

Wed, 06 November 2002 13:31

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

Run this as sys or system and provided no one is using it:

alter tablespace temp default storage (pctincrease 0);

This should clear out the tablespace.

Report message to a moderator

Previous Topic:	regarding clusters
Next Topic:	I am looking for script or utility to retrieve all statements from trace file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:52:38 CDT 2024