删除临时表空间，Oracle数据库hangs问题解决

查看临时表空间的使用情况：

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

from v$session a, v$tempseg_usage b

where a.saddr = b.session_addr 

order by b.tablespace, b.blocks;

sys@SMS> SELECT SID, SERIAL#, ST