Ref:(Who is using temp table space)

[pipo]

In oracle 8, you can see who uses sort segments with :

SELECT username, sid, serial#, contents
FROM v$session, v$sort_usage
WHERE v$session.saddr = v$sort_usage.session_addr

In oracle 7 it's a bit longer, I'll post only if needed