select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode from v$locked_object lo,dba_objects ao,v$session sess where ao.object_id = lo.object_id and lo.session_id = sess.sid; alter system kill session ‘sid,seria#’ alter system kill session '397,56293'首先查看锁住的对象，然后kill掉会话 原文链接：https://www.f2er.com/oracle/208450.html
