\u5bf9\u4e8e\u5355\u5b9e\u4f8b\u6570\u636e\u5e93\u800c\u8a00\uff0c\u6b7b\u9501\u7684\u68c0\u6d4b\u5728\u79d2\u7ea7\u5b8c\u6210\uff0c\u800cRAC\u73af\u5883\u5219\u6b7b\u9501\u7684\u68c0\u6d4b\u65f6\u95f4\u9ed8\u8ba4\u8fbe\u5230\u4e861\u5206\u949f\u3002
\n\u5bf9\u4e8e\u5355\u5b9e\u4f8b\u73af\u5883\u5982\u679c\u51fa\u73b0\u4e86\u6b7b\u9501\uff0c\u90a3\u4e48\u9a6c\u4e0a\u5176\u4e2d\u4e00\u4e2a\u8fdb\u7a0b\u5c31\u88ab\u4e2d\u6b62\uff0c\u7528\u6237\u53ef\u4ee5\u5feb\u901f\u7684\u5f97\u5230\u9519\u8bef\u8fd4\u56de\u3002\u800c\u5bf9\u4e8eRAC\u800c\u8a00\uff0c\u6b7b\u9501\u7684\u68c0\u6d4b\u5e76\u4e0d\u662f\u5b9e\u65f6\u5b8c\u6210\uff0c\u800c\u662f\u9700\u898160\u79d2\u5de6\u53f3\u7684\u65f6\u95f4\u3002
\n\u4f1a\u8bdd1\u6267\u884c\uff1a<\/p>\n
SQL> create table t_deadlock (id number primary key, name varchar2(30));\r\nTable created.\r\nElapsed: 00:00:00.12\r\nSQL> insert into t_deadlock values (1, 'a');\r\n1 row created.\r\nElapsed: 00:00:00.00\r\nSQL> insert into t_deadlock values (2, 'b');\r\n1 row created.\r\nElapsed: 00:00:00.00\r\nSQL> commit;\r\nCommit complete.\r\nElapsed: 00:00:00.00\r\nSQL> update t_deadlock set name = 'a1' where id = 1;\r\n1 row updated.\r\nElapsed: 00:00:00.00<\/pre>\n\u4f1a\u8bdd2\u6267\u884c\uff1a<\/p>\n
SQL> set timing on\r\nSQL> update t_deadlock set name = 'b2' where id = 2;\r\n1 row updated.\r\nElapsed: 00:00:00.00\r\nSQL> update t_deadlock set name = 'a2' where id = 1;<\/pre>\n\u6b64\u65f6\uff0c\u4f1a\u8bdd2\u7b49\u5f85\u4f1a\u8bdd1\u7684\u6700\u7ec8\u64cd\u4f5c\uff0c\u4e0b\u9762\u4f1a\u8bdd1\u66f4\u65b0\u88ab\u4f1a\u8bdd2\u9501\u5b9a\u7684\u884c\uff0c\u5f15\u53d1\u6b7b\u9501\uff1a<\/p>\n
SQL> update t_deadlock set name = 'b1' where id = 2;\r\nupdate t_deadlock set name = 'b1' where id = 2\r\n*\r\nERROR at line 1:\r\nORA-00060: deadlock detected while waiting for resource\r\n\r\nElapsed: 00:01:00.12<\/pre>\n\u53ef\u4ee5\u770b\u5230\uff0c\u6b7b\u9501\u7684\u8d85\u65f6\u68c0\u6d4b\u4e3a1\u5206\u949f\u3002
\n\u800c\u8fd9\u4e2a\u6b7b\u9501\u7684\u68c0\u6d4b\u65f6\u95f4\u662f\u53ef\u4ee5\u8c03\u6574\u7684\uff0cOracle\u901a\u8fc7\u9690\u542b\u53c2\u6570_lm_dd_interval\u63a7\u5236\uff1a<\/p>\n
SQL> conn \/ as sysdba\r\nConnected.\r\nSQL> alter system set \"_lm_dd_interval\" = 30 scope = spfile;\r\nSystem altered.\r\nSQL> shutdown immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL> startup\r\nORACLE instance started.\r\nTotal System Global Area 281018368 bytes\r\nFixed Size 2095672 bytes\r\nVariable Size 104859080 bytes\r\nDatabase Buffers 167772160 bytes\r\nRedo Buffers 6291456 bytes\r\nDatabase mounted.\r\nDatabase opened.<\/pre>\n\u518d\u6b21\u6d4b\u8bd5\u6b7b\u9501\u7684\u68c0\u6d4b\u65f6\u95f4\uff0c\u4f1a\u8bdd1\uff1a<\/p>\n
SQL> update t_deadlock set name = 'a1' where id = 1;\r\n1 row updated.\r\nSQL> set timing on<\/pre>\n\u4f1a\u8bdd2\u6267\u884c\u66f4\u65b0\uff1a<\/p>\n
SQL> set timing on\r\nSQL> update t_deadlock set name = 'b2' where id = 2;\r\n1 row updated.\r\nElapsed: 00:00:00.02\r\nSQL> update t_deadlock set name = 'a2' where id = 1;<\/pre>\n\u4f1a\u8bdd1\u6267\u884c\u66f4\u65b0\u5f15\u53d1\u6b7b\u9501\uff1a<\/p>\n
SQL> update t_deadlock set name = 'b1' where id = 2;\r\n\u5927\u7ea630\u79d2\u540e\uff0c\u4f1a\u8bdd2\u62a5\u9519ORA-60\uff1a\r\nupdate t_deadlock set name = 'a2' where id = 1\r\n*\r\nERROR at line 1:\r\nORA-00060: deadlock detected while waiting for resource\r\n\r\nElapsed: 00:00:30.27<\/pre>\n\u572810.2.0.2\u7248\u672c\u4e0a\uff0cOracle\u5b58\u5728\u4e00\u4e2abug\uff0c\u5141\u8bb8\u8fd9\u4e2a\u53c2\u6570\u8bbe\u7f6e\u4e3a0\uff0c\u572810.2.0.3\u4ee5\u540e\uff0c\u8fd9\u4e2abug\u88ab\u4fee\u6b63\uff0c\u5982\u679c\u8bbe\u7f6e\u4e3a0\u540e\uff0c\u5219\u6570\u636e\u5e93\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8\uff1a<\/p>\n
[oracle@node1 ~]$ sqlplus \/ as sysdba\r\nSQL*Plus: Release 10.2.0.5.0 - Production on Mon Jun 4 07:54:09 2012\r\nCopyright (c) 1982, 2010, Oracle. All Rights Reserved.\r\nConnected to an idle instance.\r\nSQL> startup\r\nORA-00067: invalid value 0 for parameter _lm_dd_interval; must be at least 1<\/pre>\n\u6700\u540e\u4fee\u6539\u9690\u542b\u53c2\u6570\u662fOracle\u4e0d\u63a8\u8350\u7684\uff0c\u800c\u4e14\u4fee\u6539\u8fd9\u4e2a\u53c2\u6570\u52bf\u5fc5\u4f1a\u5f71\u54cdRAC\u7684\u6b63\u5e38\u5de5\u4f5c\u65b9\u5f0f\u5bfc\u81f4LDM\u8fdb\u7a0b\u7684\u7e41\u5fd9\u5ea6\u589e\u52a0\uff0c\u800c\u4e14\u53ef\u80fd\u5f71\u54cdRAC\u73af\u5883\u7684\u7a33\u5b9a\u6027\u548c\u53ef\u7528\u6027\u3002
\n\u5982\u679c\u786e\u5b9e\u5bf9\u4e8e\u524d\u53f0\u7684\u6b7b\u9501\u68c0\u67e5\u65f6\u95f4\u8981\u6c42\u8f83\u9ad8\uff0c\u5efa\u8bae\u5728\u6d4b\u8bd5\u73af\u5883\u4e2d\u8be6\u7ec6\u6d4b\u8bd5\u540e\u518d\u90e8\u7f72\u5230\u4ea7\u54c1\u73af\u5883\u4e2d\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5bf9\u4e8e\u5355\u5b9e\u4f8b\u6570\u636e\u5e93\u800c\u8a00\uff0c\u6b7b\u9501\u7684\u68c0\u6d4b\u5728\u79d2\u7ea7\u5b8c\u6210\uff0c\u800cRAC\u73af\u5883\u5219\u6b7b\u9501\u7684\u68c0\u6d4b\u65f6\u95f4\u9ed8\u8ba4\u8fbe\u5230\u4e861\u5206\u949f\u3002 \u5bf9\u4e8e\u5355\u5b9e\u4f8b\u73af\u5883\u5982\u679c\u51fa\u73b0\u4e86\u6b7b\u9501\uff0c\u90a3\u4e48\u9a6c\u4e0a\u5176\u4e2d\u4e00\u4e2a\u8fdb\u7a0b\u5c31\u88ab\u4e2d\u6b62\uff0c\u7528\u6237\u53ef\u4ee5\u5feb\u901f\u7684\u5f97\u5230\u9519\u8bef\u8fd4\u56de\u3002\u800c\u5bf9\u4e8eRAC\u800c\u8a00\uff0c\u6b7b\u9501\u7684\u68c0\u6d4b\u5e76\u4e0d\u662f\u5b9e\u65f6\u5b8c\u6210\uff0c\u800c\u662f\u9700\u898160\u79d2\u5de6\u53f3\u7684\u65f6\u95f4\u3002 \u4f1a\u8bdd1\u6267\u884c\uff1a SQL> create table t_deadlock (id number primary key, name varchar2(30)); Table created. Elapsed: 00:00:00.12 SQL> insert into t_deadlock values (1, ‘a’); 1 row created. Elapsed: 00:00:00.00 SQL> insert into t_deadlock values (2, ‘b’); 1 row created. Elapsed: … Continue reading