oracle解锁

查出锁定object的session的信息以及被锁定的object名,生成kill和Linux系统kill

select b.owner,
       b.object_name,
       l.session_id,
       x.SERIAL#,
       x.username,
       x.logon_time,
       l.locked_mode,
       'alter system kill session ''' || x.sid || ',' || x.serial# || '''' killsql,
       c.spid AS os_process_id,c.pid,
       'ps -ef | grep ' ||c.spid as check_os_process_command,
       'kill -9 ' ||c.spid as kill_os_process_command
  from v$locked_object l, dba_objects b, v$session x,v$process c
  where b.object_id = l.object_id
    and l.SESSION_ID = x.SID
    and c.addr=x.paddr
  order by x.LOGON_TIME asc;

--alter system kill session 'sid,serial#' immediate;