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.