1 Reply Latest reply: Dec 11, 2012 2:30 AM by moreajays RSS

    DBA_DML_LOCKS.BLOCKING_OTHERS

    chakra
      What is the meaning of DBA_DML_LOCKS.BLOCKING_OTHERS='Global'?
        • 1. Re: DBA_DML_LOCKS.BLOCKING_OTHERS
          moreajays
          Hi,

          Blocking_others column has derived from v$lock.block whoes 0=not blocking 1=Blocking & 2=global.
          Global generally appears in RAC which indicates it has been locked by GES to processes the block across the instances as a part of cache fusion

          Thanks,
          Ajay More
          http://moreajays.blogspot.com