SELECT username,
sid,
serial#,
sql_address,
machine,
program,
tablespace,
segtype,
contents
FROM v$session se,
v$sort_usage su
WHERE se.saddr=su.session_addr
查看临时表空间的使用率
select TABLESPACE_NAME,file_id, (bytes_used+bytes_free)/1024/1024 "size_total(mb)", bytes_used/1024/1024, bytes_free/1024/1024 from V$TEMP_SPACE_HEADER;