查看临时表空间的使用情况:
SELECT USERNAME, SESSION_NUM, SESSION_ADDR FROM V$SORT_USAGE;
找出是哪个会话:
SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE SERIAL#=SESSION_NUM;
OR
SELECT SID, SERIAL#, STATUS FROM V$SESSION WHERE SADDR=SESSION_ADDR;
会话使用的表空间:
select a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks