OraFAQ Forum: SQL & PL/SQL » CLEARING TEMPORARY TABLE SPACES

Home » SQL & PL/SQL » SQL & PL/SQL » CLEARING TEMPORARY TABLE SPACES

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

CLEARING TEMPORARY TABLE SPACES [message #247564]

Tue, 26 June 2007 06:52

sathyam2627
Messages: 52
Registered: November 2006

Member

hi to all,

i am using oracle9i now a days my database is running very slow so that i checked temporary table spaces its almost all 98% filled, so kindly help me how to clear temporary table space otherwise how to recreate a temporary table space

kindly help me regarding this

regards

sathya

Report message to a moderator

Re: CLEARING TEMPORARY TABLE SPACES [message #247568 is a reply to message #247564]

Tue, 26 June 2007 06:58

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Temporary tablespace is almost always full because Oracle didn't release the space: it reuses it.
Normal situation.

Regards
Michel

Report message to a moderator

Re: CLEARING TEMPORARY TABLE SPACES [message #247584 is a reply to message #247564]

Tue, 26 June 2007 07:42

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Why do you think there is a connection between bad performance and full temp. tablespace?

Report message to a moderator

Re: CLEARING TEMPORARY TABLE SPACES [message #247695 is a reply to message #247584]

Tue, 26 June 2007 21:58

sathyam2627
Messages: 52
Registered: November 2006

Member

Hi,
thanks for ur suggestion, then wat might be the cause of bad performace. My server has been configured with high configuration.

kindly suggest me how to overcome from this, to execute a small update statements also it is taking nearly more than 15 minutes.

regards

sathya

Report message to a moderator

Re: CLEARING TEMPORARY TABLE SPACES [message #247697 is a reply to message #247564]

Tue, 26 June 2007 22:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Answers might be better if you read & followed both STICKY posts at top of this forum.

How/why do you expect us to improve SQL we have NEVER seen?

Post using code tags EXPLAIN_PLAN & table DESCRIPTIONs of all tables involved.

Try any or all of these:
http://www.orafaq.com/forum/t/84315/74940/

Report message to a moderator

Previous Topic:	to_char doesn't work with date of 1/1/1900
Next Topic:	Partioning a Table, either List or Range without Hard coding the values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 07:54:24 CST 2024