Oracle - List Locked Sessions :-
SELECT DO.owner
, DO.object_name
, DO.object_type
, vs.SID
, vs.serial#
, vs.status
, vs.osuser
, vs.machine
, vs.program
, vs.module
, vs.action
FROM v$locked_object vlo
, v$session vs
, dba_objects DO
WHERE
vs.SID = vlo.session_id
AND vlo.object_id = DO.object_id
ORDER BY module
Oracle - Kill Locked Session :-
alter system kill session 'SID,serial#'
alter system kill session '145,47805'
SELECT DO.owner
, DO.object_name
, DO.object_type
, vs.SID
, vs.serial#
, vs.status
, vs.osuser
, vs.machine
, vs.program
, vs.module
, vs.action
FROM v$locked_object vlo
, v$session vs
, dba_objects DO
WHERE
vs.SID = vlo.session_id
AND vlo.object_id = DO.object_id
ORDER BY module
Oracle - Kill Locked Session :-
alter system kill session 'SID,serial#'
alter system kill session '145,47805'