Home » SQL & PL/SQL » SQL & PL/SQL » CLEARING TEMPORARY TABLE SPACES
CLEARING TEMPORARY TABLE SPACES [message #247564] Tue, 26 June 2007 06:52 Go to next message
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
Re: CLEARING TEMPORARY TABLE SPACES [message #247568 is a reply to message #247564] Tue, 26 June 2007 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Temporary tablespace is almost always full because Oracle didn't release the space: it reuses it.
Normal situation.

Regards
Michel
Re: CLEARING TEMPORARY TABLE SPACES [message #247584 is a reply to message #247564] Tue, 26 June 2007 07:42 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Why do you think there is a connection between bad performance and full temp. tablespace?
Re: CLEARING TEMPORARY TABLE SPACES [message #247695 is a reply to message #247584] Tue, 26 June 2007 21:58 Go to previous messageGo to next message
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
Re: CLEARING TEMPORARY TABLE SPACES [message #247697 is a reply to message #247564] Tue, 26 June 2007 22:03 Go to previous message
BlackSwan
Messages: 25049
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/

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:
  


Current Time: Fri Dec 09 11:50:31 CST 2016

Total time taken to generate the page: 0.13212 seconds