标题: 快速查找oracle下锁冲突的sid [打印本页] 作者: jiawang 时间: 2020-2-25 16:53 标题: 快速查找oracle下锁冲突的sid select 'alter system kill session ''' || sid || serial#|| ''' immediate;'
from v$session
where sid=(select blocking_session from v$session where blocking_session is not null);