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 '815,46584' --sid,serial
标签：sess,锁表,object,ao,session,sql,lo,oracle,id From： https://www.cnblogs.com/szc1998/p/17641086.html