-
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.
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
|