查看当前正在使用临时段进行排序的用户[@more@]查看当前正在使用临时段进行排序的用户
select /*+ rule */
distinct a.sid, a.process, a.serial#, to_char(a.logon_time, 'YYYYMMDD HH24:MI:SS') LOGON, a.osuser,
TABLESPACE , b.sql_text
from v$session a, v$sql b, v$sort_usage c
where a.sql_address = b.address and a.saddr = c.session_addr
select /*+ rule */
distinct a.sid, a.process, a.serial#, to_char(a.logon_time, 'YYYYMMDD HH24:MI:SS') LOGON, a.osuser,
TABLESPACE , b.sql_text
from v$session a, v$sql b, v$sort_usage c
where a.sql_address = b.address and a.saddr = c.session_addr
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9523925/viewspace-1037667/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9523925/viewspace-1037667/