CODEWITHSUNDEEP
sqloracle10glocking
P Sharma
P Sharma

Reputation: 2738

How concurrency maintained by Oracle for PL/SQL Procedure?

How oracle maintained concurrency of PL/SQL Program? i.e. If user A and B both execute same procedure (Contains DML operations) @ same time.

Upvotes: 0

Views: 1370

Answers (2)

Tony Andrews
Tony Andrews

Reputation: 132680

If user A updates a particular row and then in another session user B tries to update (or delete) the same row, then user B's session will be "blocked", i.e. it will wait for user A's session to either commit or roll back before continuing. You can easily see this by opening 2 SQL Plus sessions and running the exact same update statement in both. The second session will "hang" until the first session commits or rolls back. This is true whether the updates are done in PL/SQL or not.

Upvotes: 1

Padmarag
Padmarag

Reputation: 7214

It follows general Oracle Locking features.

Oracle maintains separate session for User A and User B.

Upvotes: 0

Related Questions