快速定位行锁信息

jiawang

SELECT s.sid,s.serial#,s.username,t.xidusn,

t.xidslot,t.xidsqn, r.object_id,o.owner,o.object_name

FROM v$session s, v$transaction t,v$locked_object r, dba_objects o

WHERE s.saddr = t.ses_addr

ANDt.xidusn = r.xidusn AND r.object_id = o.object_id

ORDER BY s.sid;

登录/注册后可看大图