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.