Temporary tablespace size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Temporary tablespace size

  1. #1
    Join Date
    Sep 2001
    Posts
    163
    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.

    Thanks.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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