session 1 执行如下脚本：
SQL> begin
2 update t1 set a=10 where a=1;
3 dbms_lock.sleep(5);
4 update t2 set a=11 where a=2;
5 dbms_lock.sleep(5);
6 commit;
7 end;
8 /
begin
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 4
2 update t1 set a=10 where a=1;
3 dbms_lock.sleep(5);
4 update t2 set a=11 where a=2;
5 dbms_lock.sleep(5);
6 commit;
7 end;
8 /
begin
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at line 4
SQL>
同时 session 2 执行如下脚本：
SQL> begin
2 update t2 set a=15 where a=2;
3 dbms_lock.sleep(5);
4 update t1 set a=15 where a=1;
5 dbms_lock.sleep(5);
6 commit;
7 end;
8 /
SQL> begin
2 update t2 set a=15 where a=2;
3 dbms_lock.sleep(5);
4 update t1 set a=15 where a=1;
5 dbms_lock.sleep(5);
6 commit;
7 end;
8 /
PL/SQL procedure successfully completed.
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23382569/viewspace-761084/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle取随机数
下一篇：
消除行连接
请登录后发表评论
登录
全部评论
