Cacher is the code snippet organizer for pro developers

SELECT 'ALTER SYSTEM KILL SESSION ''' || SID || ',' || SERIAL# || ''';' KILL
, SID
, SERIAL#
, MACHINE
, ORACLE_USERNAME
, OS_USER_NAME
, LOCKED_MODE
, OBJECT_NAME
, OBJECT_TYPE
FROM V$LOCKED_OBJECT A
, DBA_OBJECTS B
, V$SESSION C
WHERE A.OBJECT_ID = B.OBJECT_ID
AND A.SESSION_ID = C.SID

use the sqls that gets returned in the KILL column and execute them to unlock the sessions.

example:

KILL                                   
---------------------------------------
ALTER SYSTEM KILL SESSION '407,11326'; 
ALTER SYSTEM KILL SESSION '3319,45251';