1.现象:在实践中经常发现死锁现象,当出现几条死锁还能手动删除,但是上百条,上千条时咋办呢?所以批量删除
2.解决办法:
select 'alter system kill session ''' || a.SID ||',' || a.SERIAL# ||''';'as tmp_sql,
a.SERIAL#,a.SQL_TRACE_BINDS,
c.OBJECT_NAME,
a.COMMAND,
a.LOCKWAIT,
a.STATUS,
a.SQL_TRACE,
a.SQL_HASH_VALUE,
a.SQL_ADDRESS,
a.SQL_ID
from v$session a, v$locked_object b, dba_objects c
where a.sid = b.SESSION_ID
and b.OBJECT_ID = c.OBJECT_ID;
向Secooler致敬!
Johnson
13-11-27
2.解决办法:
select 'alter system kill session ''' || a.SID ||',' || a.SERIAL# ||''';'as tmp_sql,
a.SERIAL#,a.SQL_TRACE_BINDS,
c.OBJECT_NAME,
a.COMMAND,
a.LOCKWAIT,
a.STATUS,
a.SQL_TRACE,
a.SQL_HASH_VALUE,
a.SQL_ADDRESS,
a.SQL_ID
from v$session a, v$locked_object b, dba_objects c
where a.sid = b.SESSION_ID
and b.OBJECT_ID = c.OBJECT_ID;
向Secooler致敬!
Johnson
13-11-27
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20985606/viewspace-1061312/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20985606/viewspace-1061312/