Stop UPDATEs hanging forever @oracledevs
Stop UPDATEs hanging forever  @oracledevs
Uploaded June 2026 | Updated November 2026, 4 days 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
Stop UPDATEs hanging foreverExadata Architecture Explained: Smart Scan, Storage Indexes, and RDMAPart 3: Whats New in APEX 26.2Natural language and graphs: Using Select AI and Select AI agentsAgent Harness Permissions: Rules Belong in Code, Not the PromptQuery Your Oracle AI Database Alert Log with Natural LanguageBuild with Oracle AI Database and ORDS MCP ServersHow to Build Your First AI Agent with Oracle AI DatabaseBuild Semantic Search for GitHub Issues with Oracle AI Database 26aiDay One and Beyond - Why Exadata? Portfolio, Architecture & Deployment ChoicesAI Engineer World Fair Day 1: Robots, Racing Sims, and Orchestrator Orcs | Oracle DevelopersOracle Access Governance (OAG) II – Self-Service Requests & Approvals
Oracle Developers |

Stop UPDATEs hanging forever

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER