select sess.username, sql.sql_text, sort1.blocks
from v$session sess, v$sqlarea sql, v$sort_usage sort1
where sess.serial# = sort1.session_num
and sort1.sqladdr = sql.address
and sort1.sqlhash = sql.hash_value and sort1.blocks > 200;
查看临时表空间占用最多的用户与SQL
原文：http://www.cnblogs.com/wdw31210/p/7687909.html
