-
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.
HTH
gtcol
Last edited by gtcol; 04-16-2009 at 01:29 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|