The new partition-level locking feature increases data availability by providing
locking to a finer granularity, which allows access to other partitions for concurrent DDL
and DML statements.
- Partition locking as an attribute of a partitioned table
- Schema locks, which allow enhanced partition-level operations to update table
schema or metadata by achieving isolation from concurrent operations
- Lock compatibility and lock sufficiency, which support issues of locking and
concurrency
- Partition-level locking, which allows access to data in tables while operations
on a subset of partitions in a table (partition-level operations) are
active