User使用临时表空间的情况

COLUMN sid_serial FORMAT A20
COLUMN username FORMAT A15
COLUMN program FORMAT A30
COLUMN undoseg FORMAT A25
COLUMN undo FORMAT A20
COLUMN MACHINE FORMAT A25
COLUMN OSUSER FORMAT A15
COLUMN CLIENT_INFO FORMAT A15
COLUMN MODULE FORMAT A15

SELECT vt.inst_id,
       vs.sid,
       vs.serial#,
       vs.username,
       vs.osuser,
       vs.machine,
       vs.saddr,
       vs.client_info,
       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;