Copyright Ó Oracle Corporation, 1999. All rights reserved.
12-12
>
UPDATE emp
SET sal = sal x 1.1
WHERE empno = 1000;
SET sal = sal x 1.1
WHERE empno = 1000;
Diagnostic Tools for Monitoring Locking Activity
V$LOCK
V$LOCKED_OBJECT
Transaction 1
> UPDATE emp
SET sal = sal x 1.1;
SET sal = sal x 1.1;
Transaction 2
Transaction 3
>
UPDATE emp
SET sal = sal x 1.1
WHERE empno = 2000;
SET sal = sal x 1.1
WHERE empno = 2000;
EM TopSessions
