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;

Report message to a moderator

Previous Topic: Re: Unable to connect to Oracle due to Missing/Currupt data files
Next Topic: oracle8i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 07:22:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.