CHAPTER 6Interpreting Locks-Related Wait Events
Concurrent database access in its simplest form can be defined as multiple sessions simultaneously reading from or writing to the database. The Oracle SGA architecture can be a lot simpler if concurrent access is the only goal of the RDBMS. However, there is another goal that supersedes concurrency in terms of importance and significance: data integrity.
The integrity of any data structure in the SGA cannot be guaranteed if multiple processes are allowed to modify the same data structure at the same time. Oracle ensures data integrity by serializing access to SGA data structures and database objects with latches and locks. In the DBMS concept, this is the “I” of the ACID properties (Atomicity, Consistency, ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
