Maison > Article > base de données > 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