Kill Sessions of using Objects From Linux Operating System

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 '%MVTRANSACTIONLOG%';

Kill Sessions of Specific Users from Database

select 'alter system kill session' || '''' || sid || ',' || serial# || '''' || 'immediate;' , username, sid,serial# from v$session where username ='NAGIOS';

Kill Session Bloking 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);