SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, c.sql_text
FROM v$session a, v$tempseg_usage b, v$sqlarea c
WHERE a.saddr = b.session_addr
AND c.address= a.sql_address
AND c.hash_value = a.sql_hash_value
ORDER BY b.tablespace, b.blocks;
-- 来自文档：How Do You Find Who And What SQL Is Using Temp Segments (文档 ID 317441.1)
找出在使用临时表空间的SQL
原文：https://www.cnblogs.com/liang545621/p/9410688.html
