如何查找并解决oracle database 的lock

select sid, serial#, last_call_et, status, program , username
from v$session
where sid
in ( select sid from v$lock where block=1)

alter system kill session '437,4315'

select
    sid
    ,serial#
    ,username
    ,taddr
    ,s.status
    ,module
    ,action
from
    v$session s
    ,v$locked_object l
where
    s.sid = l.session_id

原文转自：http://www.ltesting.net