Find and Kill session at Database Level

select 'alter system kill session' || '''' || sid || ',' || serial# || '''' || 'immediate;', username, sid,serial#,sql_id , wait_time from v$session where (sid ) in
(
select blocking_session from v$session
);

select 'alter system kill session' || '''' || sid || ',' || serial# || '''' || 'immediate;' , username, sid,serial#,sql_id , wait_time from v$session where sid in
(select holding_session from dba_blockers);

Checky user Level Locking

SELECT se.inst_id,se.last_call_et,
lk.SID, se.username, se.OSUser, se.Machine,DECODE (lk.TYPE,'TX', 'Transaction','TM', 'DML','UL', 'PL/SQL User Lock',lk.TYPE)
lock_type, DECODE (lk.lmode, 0, 'None', 1, 'Null',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share',
5, 'S/Row-X (SSX)',
6, 'xclusive',
TO_CHAR (lk.lmode))
mode_held,
DECODE (lk.request,
0, 'None',
1, 'Null',
2, 'Row-S (SS)',
3, 'Row-X (SX)',
4, 'Share',
5, 'S/Row-X (SSX)',
6, 'Exclusive',
TO_CHAR (lk.request))
mode_requested,
TO_CHAR (lk.id1) lock_id1,
TO_CHAR (lk.id2) lock_id2,
ob.owner,
ob.object_type,
ob.object_name,
DECODE (lk.Block, 0, 'No', 1, 'Yes', 2, 'Global') block,
se.lockwait
FROM GV$lock lk, dba_objects ob, GV$session se
WHERE lk.TYPE IN ('TX', 'TM', 'UL')
AND lk.SID = se.SID
AND lk.id1 = ob.object_id(+)
AND lk.inst_id = se.inst_id
and last_call_et > 100;

Kill Session at OS find Used Objects

select /+rule+/ 'kill -9 ' || c.spid from v$access a , v$session b ,v$process c
where a.sid=b.sid
and c.addr=b.paddr
and a.object like '%F_BATCH%';