Kill session for lock

1. find target session.

SELECT aob.object_name
,aob.object_id
,b.process
,b.session_id,c.SID, c.SERIAL#,c.LOGON_time,c.seconds_in_wait, c.state
FROM all_objects aob, v$locked_object b, v$session c
WHERE aob.object_id = b.object_id
and b.session_id = c.sid


2. delete session.

alter system kill session '<sid>,<serial>'