如何查到oracle dml lock和如何解决

检查dml lock的脚本：dmllocks.sql

Doc

Name: dmllocks.sql

Author: Jassie

Description:This script shows current dml locks on the system

#

select session_id, owner,name,MODE_HELD

from sys.dba_dml_locks;

查到了session_id，把他kill掉就行了，一下的脚本会执行这个：killses.sql

Doc

Name:killses.sql

Author:James Xie

Purpose: To kill a session easily by its session id

#

col col1 new_value serialno

select SERIAL# col1 from v$session

where sid=&1

/

alter system kill session '&1, &serialno'

/

undefine 1

根据提示输入session_id