| Temp table space not released [message #402741] |
Tue, 12 May 2009 05:00  |
someswar1
Messages: 53
Registered: January 2008
|
Member |
|
|
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 ??
Regards
Someswar
|
|
|
|
| Re: Temp table space not released [message #402750 is a reply to message #402741] |
Tue, 12 May 2009 05:36  |
 |
Mahesh Rajendran
Messages: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
