Cluster Level Locks

  • Only one cluster level lock can be taken at a time.

  • If a cluster level lock is taken, it will block any database locks from being taken.

  • DML operations are not affected by these locks.

  • DDL operations that are affected by these locks are listed in Operations that Take Cluster Level Locks

  • Any blocked operations will queue.

Example: ADD LEAF is running on the cluster. While the operation is running, CREATE TABLE tries to run, but is blocked until ADD LEAF completes.

Last modified: August 30, 2022

Was this article helpful?