Temp tablespace file grew to 32GB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Temp tablespace file grew to 32GB

Threaded View

  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Temp tablespace file grew to 32GB

    Hi!
    I have Oracle 9i Standard server on Windows 2000 Server. I had Temp tablespace file grow to its limit of 32GB. Since the database had no other files in the tablespace I created another file for temporary solution.

    The data in the database use about 8.6GB, and I am wondering what could cause such growth. If this is a query, is there a way to trace it? I am also looking for the best way to decrease the space of the database. My colleague proposes that I just drop the file and recreate it. Is that safe? Is there a way to just free up some space in the file and then shrink it?

    Thanks.
    Last edited by Fish; 11-21-2005 at 10:29 PM.

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