Oracle临时表空间问题小结

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<6;