10.4.3 死锁

SQL> select sid from v$mystat where rownum=1;
SID
----------
159
SQL> update employees set last_name=last_name||'a' 
where employee_id=100;
1 row updated.

SQL> select sid from v$mystat where rownum=1;
SID
----------
158
SQL> update employees set last_name=last_name||'b' where 
employee_id=101;
1 row updated.

SQL> update employees set last_name=last_name||'c' 
where employee_id=101;

SQL> update employees set last_name=last_name||'d' where employee_id=100;

SQL> update employees set last_name=last_name||'c' where
employee_id=101;
update employees set last_name=last_name||'c' where employee_id=101
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource

Sat Dec 15 01:19:20 2007
ORA-00060: Deadlock detected. More info in file /u01/app/
oracle/admin/ora10g/udump/ora10g_ ora_3813.trc.