ITPUB

Sep 5, 2016 · Databases

Understanding Oracle Enqueue Locks, Resource Structures, and Hash Tables

This article explains how Oracle protects shared resources with enqueue queues, details the naming of TM queue locks per table, describes the resource structure (KSQRS) that tracks owners, waiters and converters, and shows how hash tables and related parameters manage these structures efficiently.