select
s.SID,s.SERIAL#,s.USERNAME,r.STATUS,S.LOGON_TIME,N.name,seg.tablespace_name
from
v$session s,
v$process p,
v$transaction t,
v$rollstatr,
v$rollnamen,
dba_rollback_segs seg
where s.paddr = p.addr
and s.taddr = t.addr (+)
and t.xidusn = r.usn (+)
and r.usn = n.usn (+)
and n.name = seg.segment_name(+)
在很早以前我根據這條sql查過,結果發現是分布式事務失敗卻沒有rollback,後來就orakill xxx spid 就自動縮小,這次好像不是分佈式事務所造成的 |