This discussion is archived
1 Reply Latest reply: Dec 11, 2012 12:30 AM by moreajays RSS

DBA_DML_LOCKS.BLOCKING_OTHERS

chakra Explorer
Currently Being Moderated
What is the meaning of DBA_DML_LOCKS.BLOCKING_OTHERS='Global'?
  • 1. Re: DBA_DML_LOCKS.BLOCKING_OTHERS
    moreajays Pro
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points