select a_s.owner,
  a_s.object_name,
  a_s.object_type,
  vn.sid,
  vn.serial#,
  vs.spid "os_pid",
  vn.process "client_pid",
  vn.username,
  vn.osuser,
  vn.machine "hostname" ,
  vn.terminal,
  vn.program,
  to_char(vn.logon_time,'yyyy-mm-dd hh24:mi:ss')"login_time",
  'alter system kill session '''||vn.sid||','||vn.serial#||''';' "oracke_kill",
  'kill -9 '|| vs.spid "os_kill"
from all_objects a_s,
  v$locked_object v_t,
  v$session vn,
  v$process vs
where a_s.object_id=v_t.object_id
and v_t.session_id =vn.sid
and vs.addr=vn.paddr
and vn.username not in('SYSMAN','SYS');