TEMP-segment usage

select s.sid
,s.client_identifier
,s.status
,sum(round(u.blocks*8192/1024/1024,3)) "TEMP usage, Mb"
,s.osuser, s.machine, s.module, s.action
from v$session s,
v$sort_usage u
where s.saddr = u.session_addr
and u.blocks*8192/1024 > 128 -- exclude no matter values
group by s.sid, s.osuser, s.machine, s.module, s.action, s.client_identifier,s.status
order by "TEMP usage, Mb" desc