Home » RDBMS Server » Server Administration » Temp table space not released (Oracle 10G)
Temp table space not released [message #402741] Tue, 12 May 2009 05:00 Go to next message
Messages: 53
Registered: January 2008

Hi All,
While running all store proc I found that, they are using temp table space for different operations but after completion they are not releasing the table space accordingly. As a result Temp table space becomes 100%. I are not able to release it other than restart the database which not a good solution at all. Please Suggest ??



Re: Temp table space not released [message #402750 is a reply to message #402741] Tue, 12 May 2009 05:36 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you running into any errors?
A full temporary tablespace is expected behavior as the extents are not de-allocated. Perfectly normal.
If you are running out temp space and your operations fail,
post what kind of operations you are doing. Depending on that,
you may need to extend the tablespace.

Next Topic: Restrict writing startup information into alert log
Goto Forum:

Current Time: Fri Jul 21 01:53:26 CDT 2017

Total time taken to generate the page: 0.16183 seconds