Increased Data Availability with Partition Locking
The partition-level locking feature increases data availability by creating finer
locking granularity, which allows access to other partitions for concurrent DDL and DML
statements.
- Partition Locks
Partition locks are an attribute of a partitioned table and are applicable to all types of partitioning.
- Partition Lock Promotion
Table lock promotion promotes locks from fine-grained locks to table locks. Partition lock promotion promotes locks from fine-grained locks to partition locks.
- Lock Compatibility and Lock Sufficiency
Lock compatibility and lock sufficiency are two basic concepts that support issues of locking and concurrency.
- Improved Concurrency for Partition-Level Online Operations
Certain partition-level operations can concurrently operate on different partitions of a table. DML can also concurrently operate on the table while the partition level online operation is running.
Created April 2, 2014. Send feedback on this help topic to Technical Publications:
pubs@sap.com