Copyright Ó Oracle Corporation, 1999. All rights reserved.
12-15
Transaction
2
Transaction
1
Deadlocks
>
UPDATE emp
SET sal = sal x 1.1
WHERE empno = 1000;
SET sal = sal x 1.1
WHERE empno = 1000;
UPDATE emp
SET sal = sal x 1.1
WHERE empno = 2000;
SET sal = sal x 1.1
WHERE empno = 2000;
ORA-00060:
Deadlock detected while waiting for resource
Deadlock detected while waiting for resource
>
UPDATE emp
SET mgr = 1342
WHERE empno = 2000;
SET mgr = 1342
WHERE empno = 2000;
>
UPDATE emp
SET mgr = 1342
WHERE empno = 1000;
SET mgr = 1342
WHERE empno = 1000;
9:00
9:15
9:16
