SELECT S2.SID,s2.MACHINE,S2.SQL_HASH_VALUE,S.SQL_TEXT,s1.SOFAR/s1.TOTALWORK,s1.SOFAR,s1.TOTALWORK
FROM V$SESSION_LONGOPS S1,V$SESSION S2,v$SQLTEXT S
WHERE S1.SID=S2.SID AND S1.SERIAL#=S2.SERIAL#
AND S.HASH_VALUE(+)=S2.SQL_HASH_VALUE
AND S2.STATUS='ACTIVE'
and s1.SOFAR/s1.TOTALWORK<>1
and s1.TOTALWORK<>0
ORDER BY S2.SID, S2.SQL_HASH_VALUE,S.PIECE
FROM V$SESSION_LONGOPS S1,V$SESSION S2,v$SQLTEXT S
WHERE S1.SID=S2.SID AND S1.SERIAL#=S2.SERIAL#
AND S.HASH_VALUE(+)=S2.SQL_HASH_VALUE
AND S2.STATUS='ACTIVE'
and s1.SOFAR/s1.TOTALWORK<>1
and s1.TOTALWORK<>0
ORDER BY S2.SID, S2.SQL_HASH_VALUE,S.PIECE
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25585951/viewspace-692574/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
请登录后发表评论
登录
全部评论
