Uploaded June 2026 | Updated September 2026, 3 weeks ago
If one transaction updates a row, all other attempts to change it must wait for the first transaction to finish. When many transactions try to change the same rows at the same time, the DML statements can be stuck hanging for a long time. This gives a poor user experience.
Oracle AI Database 26ai adds functionality to avoid this issue. The wait clause for all DML enables you specify a timeout when blocked. Priority transctions enable high priority processes to steal locks from lower priority processes. And reservable columns allow many sessions to update a row at the same time.
Watch this session to learn how these work and see demos of them in action. Highlights include:
00:40 - Demo of blocked SQL
08:20 - Throw error when blocked
14:25 - DML [no]wait demo
23:30 - Stealing locks
26:00 - Transaction priority demo
33:30 - Beware low priority transactions
37:55 - Concurrent updates
40:30 - Reservable columns demo
55:15 - Recap
If one transaction updates a row, all other attempts to change it must wait for the first transaction to finish. When many transactions try to change the same rows at the same time, the DML statements can be stuck hanging for a long time. This gives a poor user experience.
Oracle AI Database 26ai adds functionality to avoid this issue. The wait clause for all DML enables you specify a timeout when blocked. Priority transctions enable high priority processes to steal locks from lower priority processes. And reservable columns allow many sessions to update a row at the same time.
Watch this session to learn how these work and see demos of them in action. Highlights include:
00:40 - Demo of blocked SQL
08:20 - Throw error when blocked
14:25 - DML [no]wait demo
23:30 - Stealing locks
26:00 - Transaction priority demo
33:30 - Beware low priority transactions
37:55 - Concurrent updates
40:30 - Reservable columns demo
55:15 - Recap
