如何查到oracledmllock和如何解决

检查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