oracle锁表语句执行提示无法终止当前对话_Oracle故障排查之oracle解决锁表问题

--step 1：查看被阻塞会话等待事件

select sid, event, username, lockwait, sql.sql_text

from v$session s, v$sql sql

where s.sql_id = sql.sql_id

and sql.sql_text like '%&sql%';

-------------------------------------------------------------------------

22    enq: TX - row lock contention    SCOTT    000000007F8C4DD8    update emp set ename='dbking' where empno=7369

23    enq: TX - row lock contention    SCOTT    000000007F8C4F98    delete from emp where empno=7499

--step 2：查找阻塞的blocker

select sid, inst_id, blocking_instance, blocking_session

from gv$session

where sid = 22;

-----------------------------------------------------------------------

22    1    1    142

或

select sid, inst_id, blocking_instance, blocking_session

from gv$session

where sid in (22, 23);