Temporary tablespace not releasing space after restart

[ggnanaraj]

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.

[Mohith123]

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.

[gtcol]

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.

HTH
gtcol