Learn how “23c lock-free reservation” eliminates the need to code your own locking mechanisms!
Application developers are all too familiar with locking and blocking issues encountered by OLTP applications when multiple sessions attempt to update the same row of a table. 23c provides a declarative mechanism called a “Lock-Free Reservation” that “allows multiple concurrent updates on a numeric column value to proceed without being blocked by uncommitted updates when adding or subtracting from the column value.” (Source Oracle Database 23c Concepts Guide)
This free tutorial demonstrates a typical concurrency issue, how to create “reservable” columns and their basic use to solve concurrency issues.
Presenter: John Watson, SkillBuilders Certified Master Oracle DBA
Download the scripts and slides for this presentation: https://skillbuilders.com/wp-content/uploads/2023/12/23c-lock-free-reservations.zip
Course Features
- Lecture 1
- Quiz 0
- Duration 9 minutes
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
