SELECT r.name "ROLLBACK SEGMENT NAME ",l.sid "ORACLE PID",p.spid "SYSTEM PID ",s.username "ORACLE USERNAME"
FROM v$lock l, v$process p, v$rollname r, v$session s
WHERE l.sid = p.pid(+) AND s.sid=l.sid AND TRUNC(l.id1(+)/65536) = r.usn AND l.type(+) = 'TX' AND l.lmode(+) = 6 ORDER BY r.name;
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
http://www.cndba.cn/cndba/dave/article/1722
版权声明：本文为博主原创文章，未经博主允许不得转载。
CNDBA社区
