捕获排序SQL语句
捕获引发排序的sql语句脚本：getsort.sql
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.sql_address=c.sqladdr;
/
阅读(2433) | 评论(0) | 转发(0) |
