Need help on temp-usage

I urgently need a way to figure out which user and which sql is causing my temporary tablespace to fill up. DBA_SEGMENTS show a segment which takes up 1GB but the owner is SYS. I think that's because the sorts or whatever is done by the system on behalf of the user. Is there a sure way of seeing who & what is the cause?

Any help much appreciated. Plz reply to the NG. Received on Thu Jun 10 1999 - 04:26:57 CDT