| TEMP tablespace locked. [message #62630] |
Wed, 04 August 2004 04:55 |
Lisa
Messages: 31
Registered: September 2000
|
Member |
|
|
Hi,
Our temp tablespace on our production database was full and unable to release resources even there was no application process going on but the background process plus the dbsnmp, the latest processes were data loading , which had been finished or interrupted.
We expected to see the temp tablespace frees up but it didn’t happen. Since the Temp tablespace was locally managed, we cannot use syntax 'alter tablespace ... default storage..' to free space as we usually do for dictionary managed tablespaces. Eventually we set the datafiles of the temp tablespace as auto extended for a tempoary solution.
Finally, we need to bounce the database. Sometimes works and sometimes don’t. and it happened constantly. It happend on 8i before and I heard it was bug. But now we already upgraded to 9i. Any idea what causing this? Any suggestions how to fix this?
Many thanks!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
