How can i identify SQL statements that used up space in temp segment?

Thanks dbtoo and KenEwald :) Actually im a newbie DBA and i dont know yet the statspack you're saying. Any other option aside from running statspack?

Harry,

Didn't know you were new to Oracle, sorry.

I'm not a big fan of this guy, but ...

Quickly find Oracle Session hogs

If you don't have OEM (Oracle Enterprise Manager), running statspack is not that tough. I'd recommend you muster up the courage and figure it out and collect stats for a day, the report will probably suprise you.

Oracle9i Database Performance Tuning Guide and Reference

Thanks a lot KenEwald :)

No worries Harry.