如何查看临时表空间都是被什么SQL占用？

SELECT vt.inst_id,
vs.sid,
vs.serial#,
vs.machine,
vs.saddr,
vs.program,
vs.module,
vs.logon_time,
vt.tempseg_usage,
vt.segtype
FROM gv$session vs, ( SELECT inst_id, username, session_addr, segtype, ROUND (SUM (blocks) * 8192 / 1024 / 1024 / 1024, 2) tempseg_usage FROM gv$tempseg_usage
GROUP BY inst_id,
username,
session_addr,
segtype
ORDER BY 4 DESC) vt
WHERE vs.inst_id = vt.inst_id AND vs.saddr = vt.session_addr
ORDER BY tempseg_usage DESC;