查出锁定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;
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;