Copyright Ó Oracle Corporation, 1999. All rights reserved.
12-14
9:00
9:05
10:30
11:30
Transaction 1
Guidelines: Resolve Contention
>
UPDATE emp
SET sal = sal x 1.1
WHERE empno = 1000;
SET sal = sal x 1.1
WHERE empno = 1000;
>COMMIT/ROLLBACK;
>
>
UPDATE emp
SET sal = sal x 1.1
WHERE empno = 1000;
SET sal = sal x 1.1
WHERE empno = 1000;
1
row updated;
>
Transaction 2
>ALTER SYSTEM KILL SESSION ‘10,23’;
