From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Data concurrency

Data concurrency - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Data concurrency

“

- [Instructor] Now that you understand ACID and that Oracle will guarantee as part of database isolation that each transaction will be processed sequentially, we step into data concurrency. Although this might sound like it contradicts the isolation guarantee of ACID transactions, concurrency has to do with how Oracle handles the simultaneous requests from applications, users, and jobs to objects and rows of data. The logic behind transactional flow, what transaction is granted a row lock, how to manage complex logic inside executed code, all the way to the commit of a transaction, is an important aspect of concurrency in Oracle 23c. In Oracle, multiple users can have access to the database with their own user session and run simultaneously. Access to change objects is controlled by Oracle's locking mechanism, which grants temporary ownership over an object at different levels in the database. Oracle's robust locking mechanism keeps from anyone needing to request exclusive locks and…

Contents