ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

?

参考网址：http://blog.csdn.net/zq9017197/article/details/6909873

http://kms.lenovots.com/kb/article.php?id=3626?（这篇比较重点，主要讲锁的概念）

?

查看是锁情况

select s.sid,s.serial#,s.username,to_char(s.logon_time,'yyyy-mm-dd hh24:mi:ss'),l.process,l.locked_mode ??

from v$locked_object l,v$session s where s.sid = l.session_id; ?

?

释放锁demo

alter system kill session '192,36381';?

192：sid

36381：serial#

?

?