A sufficiency matrix table for partition locks.
| Is That Lock Sufficient if the Task Needs: | ||||||
|---|---|---|---|---|---|---|
| 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 | Yes | Yes | Yes | Yes | Yes | Yes |
| 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 | No | No | Yes | No | No |
| An exclusive covering partition lock | No | No | No | No | Yes | Yes |
| A shared covering partition lock | No | No | No | No | No | Yes |