Partition Lock Compatibility

A summarized table about partition lock compatibility, showing when locks can be acquired immediately.

  Can Another Process Acquire:
Lock Type Held: An Exclusive Partition Lock? A Shared Partition Lock? An Exclusive Intent Partition Lock? A Shared Intent Partition Lock? An Exclusive Covering Partition Lock? A Shared Covering Partition Lock?
An exclusive partition lock No No No No No No
A shared partition lock No Yes No Yes No Yes
An exclusive intent partition lock No No Yes Yes No No
A shared intent partition lock No Yes Yes Yes No Yes
An exclusive covering partition lock No No No No Yes Yes
A shared covering partition lock No Yes No Yes Yes Yes