1 Reply Latest reply: Dec 19, 2013 8:30 AM by user10890219 RSS

    Blocking session

    user10890219

      Hi all friends,

       

      I want to find out blocking sessions between 3.00 am to 7.00 am on dec 18,2013. Could some one help me on this please. I have a script and i would appreciate if someone can help me out to modify it.

       

      SELECT s1.username || '@' || s1.machine

          || ' ( SID=' || s1.sid || ' )  is blocking '

          || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status

          FROM v$lock l1, v$session s1, v$lock l2, v$session s2

          WHERE s1.sid=l1.sid AND s2.sid=l2.sid

          AND l1.BLOCK=1 AND l2.request > 0

          AND l1.id1 = l2.id1

          AND l2.id2 = l2.id2

      /