重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 快速定位行锁信息 [打印本页]

作者: jiawang 时间: 前天 19:55
标题: 快速定位行锁信息

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;