Oracle 查询关于临时表的进程

select ‘alter system kill session ‘’’||a.sid||’,’||a.serial#||’’’ immediate;’
from
v$sessiona,v$sort_usage b,
v$processc,v$parameter d
where
d.name = ‘db_block_size’
and
a.saddr = b.session_addr
and
a.paddr = c.addr
and
b.tablespace=‘TEMP’ – 需要收缩或者删除的临时表空间名称
order by
b.tablespace,
b.segfile#,
b.segblk#,
b.blocks;