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