1gt;用户临时缺省表空间的切换--查询用户缺省临时表空间sqlgt; select username,temporary_tablespace from dba_users;usernam
select * from
(select sess.username,sess.sid,sess.serial#,segtype,blocks*8/1024 mb,sql_text
from v$sort_usage sort, v$session sess ,v$sql sql
where sort.session_addr = sess.saddr
and sql.address = sort.sqladdr (+)
order by blocks desc
) a
where rownum
，