4 Replies Latest reply: Apr 19, 2012 4:53 AM by user13722488 RSS

    Finding Locking SID in RAC environments

    user13722488
      Hi,

      I am working on an application built on 4 node RAC. I am applying a patch and the patching session is getting blocked.

      I have used below query to find the locking SID.

      select INST_ID, SID, SERIAL#, BLOCKING_SESSION, BLOCKING_SESSION_STATUS, SECONDS_IN_WAIT from gv$session where SID='4321';


      Say the output is : patching SID is 4321 running on node 2 and locking SID is 1234.

      Can anyone please give some query to find from which node 1234 is locking my patching session. Say worst case that all 4 nodes have SID with 1234.

      I need output in the way "1234 is locking your patching session 4321 from node N"

      Thanks,
      S