select * from v$session_wait
where sid = 14 and event not in 
       ('SQL*Net message from client', 
        'SQL*Net message to client', 
        'jobq slave wait');

select * from v$session where sid = 14

select * from v$session where sid = 14

SELECT   
	 A.tablespace_name TABLESPACE,
         D.mb_total,
         SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,
         D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free
FROM     v$sort_segment A,
         (
         SELECT   B.name, C.block_size, SUM (C.bytes) / 1024 / 1024 mb_total
         FROM     v$tablespace B, v$tempfile C
         WHERE    B.ts#= C.ts#
         GROUP BY B.name, C.block_size
         ) D
WHERE    A.tablespace_name = D.name
GROUP BY A.tablespace_name, D.mb_total


SELECT   S.sid || ',' || S.serial# sid_serial, S.username, S.osuser, P.spid, S.MODULE,
         S.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.TABLESPACE,
         COUNT(*) sort_ops
FROM     v$sort_usage T, v$session S, dba_tablespaces TBS, v$process P
WHERE    T.session_addr = S.saddr
AND      S.paddr = P.addr
AND      T.TABLESPACE = TBS.tablespace_name
GROUP BY S.sid, S.serial#, S.username, S.osuser, P.spid, S.MODULE,
         S.program, TBS.block_size, T.TABLESPACE
ORDER BY sid_serial


SELECT   S.sid || ',' || S.serial# sid_serial, S.username,
         T.blocks * TBS.block_size / 1024 / 1024 mb_used, T.TABLESPACE,
         T.sqladdr address, Q.hash_value, Q.sql_text
FROM     v$sort_usage T, v$session S, v$sqlarea Q, dba_tablespaces TBS
WHERE    T.session_addr = S.saddr
AND      T.sqladdr = Q.address (+)
AND      T.TABLESPACE = TBS.tablespace_name
ORDER BY S.sid


SELECT   b.TABLESPACE, b.segfile#, b.segblk#, b.blocks, a.SID, a.serial#,
         a.username, a.osuser, a.status
    FROM v$session a, v$sort_usage b
   WHERE a.saddr = b.session_addr
ORDER BY b.blocks, b.TABLESPACE