oracle kill session
SELECT o.object_id,s.sid,s.serial#,o.object_type,o.object_name,
l.oracle_username,os_user_name,locked_mode,s.program
FROM v$locked_object l,dba_objects o,v$session s
WHERE l.object_id = o.object_id AND l.session_id=s.sid
ALTER SYSTEM KILL SESSION ’sid,serial’
kaynak:http://blog.harunpeksen.net/2007/07/oracleda-kill-process-ilemi.html