Temporary tablespace not releasing space after restart
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Temporary tablespace not releasing space after restart

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    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.

  2. #2
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    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.

  3. #3
    Join Date
    Oct 2006
    Posts
    175
    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 02: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
  •  


Click Here to Expand Forum to Full Width