Temporary tablespace not releasing space after restart
We are facing a scenario where the temporary tablespace is using about 2 GB space (allocated 12 GB). However, even after bouncing the database, this 2 GB is not released. I was earlier expecting it to be released once all sessions to the database are cleaned up.
Has anyone faced a similar issue in 9i with temporary tablespaces?
Thanks in advance.
check the views v$sort_usage and see what is the usage of temp,also you can try changing the default temporary tablespace for the instance and then drop the existing temp tablespace.
May need to bounce the OS itself; sometimes, the OS processes create a lock. I encountered this in RHEL 4 some time back. Also try resizing TEMP TS to smaller size.
Last edited by gtcol; 04-16-2009 at 01:29 AM.
Click Here to Expand Forum to Full Width