Home » RDBMS Server » Server Administration » UPDATES, multiple-row-locks, deadlocks
UPDATES, multiple-row-locks, deadlocks [message #369167] Mon, 03 April 2000 17:04
KB Sriram
Messages: 1
Registered: April 2000
Junior Member
Do exclusive row locks get acquired "atomically"
when multiple rows are changed from a single UPDATE
statement?

E.g., can this statement cause deadlocks when called
concurrently from multiple sessions?

UPDATE test_dl
SET foo = foo + 1
WHERE cnt BETWEEN 1 AND 100;
COMMIT;
Previous Topic: Re: Unable to connect to Oracle due to Missing/Currupt data files
Next Topic: oracle8i
Goto Forum:
  


Current Time: Fri Oct 23 17:26:42 CDT 2020