Types of buffer locks
The database server uses two types of locks to manage access to shared-memory buffers.
The two types of locks are:
- Share locks
- Exclusive locks
Each of these lock types enforces the required level of thread isolation during execution.