--DM8查询达梦数据库-事务锁关联关系
--dm8 --03134284457-20250728-285261-20151
SELECT S.CREATE_TIME,L.LMODE,L.LTYPE,S.SQL_TEXT,S.STATE,S.SESS_ID,S.USER_NAME,L.THRD_ID FROM V$LOCK L,V$SESSIONS S,DBA_OBJECTS O
WHERE L.TABLE_ID=O.OBJECT_ID AND S.TRX_ID=L.TID
ORDER BY S.STATE