XML and XML table space lock modes
This information describes the modes of XML locks and XML table space locks
- S (SHARE)
- The lock owner and any concurrent processes can read the locked XML data. Concurrent processes can acquire an S lock on the XML data. The purpose of the S lock is to reserve the space used by the XML data.
- X (EXCLUSIVE)
- The lock owner can read, update, or delete the locked XML data. Concurrent processes cannot access the XML data.