DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    The temporary tablespace on one of our databases keeps growing. I drop and recreate the tablespace to get it to a smaller size and then it grows very large. Is there anything that I can run/look at to see what is causing this explosive growth? (from 55 meg at creation to 1.8 gig now - two weeks later). I understand that sorts and queries with distinct, etc use the temp space, but I would like more exacting detail.


  2. #2
    Join Date
    Nov 2000
    TEMP will use what TEMP will use. In other words, if the load on your database is such that TEMP keeps growing to 2G, then you probably need 2G of TEMP space. TEMP will be re-used when necessary, but you may actually be slowing things down by constantly resizing TEMP.

    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.