I was wondering why my temporary tablespace is growing so fast. Is there anything I can do about it? I think our application is opening a lot of cursors and that's causing the problem. Is there a way to free up the space on the temp tablespace? At the moment the size has grown to about 300 Megs.
That's what I thought. I can't have our developers breath down my neck. By the way, I am not running an OLTP, it more or less a DWH. I am not used to seeing that much growth on the TEMP tablespace, but they are developing a GUI tool that I think does a lot of order by and sorting. Is there anything I should do or should be aware of at this point?