[Oracle] [DBA] 追蹤table被lock的原因

1. 找出lock的session

SELECT * FROM V$LOCK WHERE BLOCK > 0 OR REQUEST > 0 ORDER BY ID1,ID2,BLOCK DESC;

2. 把上面的sid帶入 (ex: 1755)

SELECT * FROM V$SESSION WHERE SID IN ( 1755 )

3. 找出被lock的table (ex: users)

SELECT * FROM DBA_DML_LOCKS WHERE NAME='USERS'

4. 查看是什麼SQL語法造成上面table被lock

SELECT * FROM V$SQL WHERE HASH_VALUE=2803307291