ORA-04021：timeout occurred while waiting to lock object ...

ORA-04021：timeout occurred while waiting to lock object ...

应用上发现错误ORA-04021：timeout occured while waiting to lock object ...，表示是一个过程被锁住。

解决如下：

1.SELECT DISTINCT a.sid,username,b.kglnaobj
FROM V$SESSION a, sys.x$kglob b, sys.x$kglpn c
where c.kglpnhdl = b.kglhdadr
AND a.SADDR = c.kglpnuse
and b.kglnaobj like'%被锁住的对象名%';

2.select sid,serial#  from v$session where sid=?

3.alter system kill session 'sid,serial#';