Temp Space Usage Check

/**************************************************************/
-- To see who is using the tempspace
/**************************************************************/
SELECT DISTINCT
C.USERNAME "USER",
C.OSUSER ,
C.SID,
C.SERIAL#,
B.SPID "UNIX_PID",
C.MACHINE,
C.PROGRAM "PROGRAM",
A.BLOCKS * E.BLOCK_SIZE/1024/1024 MB_TEMP_USED  ,
A.TABLESPACE,
D.SQL_TEXT
FROM
V$SORT_USAGE A,
V$PROCESS B,
V$SESSION C,
V$SQLAREA D,
DBA_TABLESPACES E
WHERE C.SADDR=A.SESSION_ADDR
AND B.ADDR=C.PADDR
AND C.SQL_ADDRESS=D.ADDRESS(+)
AND A.TABLESPACE = E.TABLESPACE_NAME
/