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 '4475,31174';
ALTER SYSTEM KILL SESSION '4404,14493';