A region is a database-specific synchronization mechanism for synchronizing exclusive task access to a critical section in the working memory.
Name |
Used for |
Description |
---|---|---|
Region |
Data Cache |
EXCLUSIVE When a task accesses a critical section, the associated region blocks this critical section for all other tasks. |
Reader-writer lock (share lock) |
Catalog Cache Shared SQL Cache |
EXCLUSIVE If a task write-accesses a critical section, the associated reader-writer lock (share lock) blocks this critical section for all other task accesses. SHARED If a task read-accesses a critical section, the associated reader-writer lock (share lock) blocks this critical section for all task write-accesses but allows other task read-accesses. |
Concepts of the Database System, Working Memory Areas
Database Administration in CCMS, Critical Sections