RAC环境下的阻塞(blocking blocked)(2)

[oracle@Linux-01 ~]$ more block_session_rac2.sql
SELECT DISTINCT
          s1.username
      || '@'
      || s1.machine
      || ' ( INST='
      || s1.inst_id
      || ' SID='
      || s1.sid
      || ' Serail#='
      || s1.serial#
      || ' ) IS BLOCKING '
      || s2.username
      || '@'
      || s2.machine
      || ' ( INST='
      || s2.inst_id
      || ' SID='
      || s2.sid
      || ' Serial#='
      || s2.serial#
      || ' ) '
          AS blocking_status
  FROM gv$lock l1,
      gv$session s1,
      gv$lock l2,
      gv$session s2
 WHERE    s1.sid = l1.sid
      AND s2.sid = l2.sid
      AND s1.inst_id = l1.inst_id
      AND s2.inst_id = l2.inst_id
      AND l1.block > 0
      AND l2.request > 0
      AND l1.id1 = l2.id1
      AND l1.id2 = l2.id2;

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

Linux-6-64下安装Oracle 12C笔记

CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

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

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/01ddd8bc981a46bb09a1c804fa113b80.html