{"id":693,"date":"2012-03-26T23:49:32","date_gmt":"2012-03-26T15:49:32","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=693"},"modified":"2012-03-30T00:14:11","modified_gmt":"2012-03-29T16:14:11","slug":"11gr2%e8%ae%bf%e9%97%aevlock%e8%a7%86%e5%9b%be%e5%87%ba%e7%8e%b0%e6%80%a7%e8%83%bd%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=693","title":{"rendered":"11gr2\u8bbf\u95eeV$LOCK\u89c6\u56fe\u51fa\u73b0\u6027\u80fd\u95ee\u9898"},"content":{"rendered":"<p>\u5728Oracle 11.2.0.3 For Linux X64\u73af\u5883\u4e2d\uff0c\u78b0\u5230\u8fd9\u4e2a\u95ee\u9898\u3002<br \/>\n\u68c0\u67e5\u6570\u636e\u5e93\u662f\u5426\u5b58\u5728\u9501\u4fe1\u606f\uff0c\u5728\u67e5\u8be2V$LOCK\u89c6\u56fe\u65f6\u53d1\u73b0\u5f88\u957f\u65f6\u95f4\u6ca1\u6709\u54cd\u5e94\uff0c\u751a\u81f3\u4e00\u5ea6\u8ba4\u4e3a\u6570\u636e\u5e93HANG\u4f4f\uff1a<\/p>\n<pre lang='SQL'>SQL> select * from v$lock where type != 'MR';\r\nADDR             KADDR             SID TY      ID1  ID2 LMODE REQUEST CTIME BLOCK\r\n---------------- ---------------- ---- -- -------- ---- ----- ------- ----- -----\r\n0000000C5A6AA770 0000000C5A6AA7C8 3405 TO     5124    2     3       0  8543     0\r\n0000000C5A6AAA10 0000000C5A6AAA68 3405 TO     5124    1     3       0  8543     0\r\n00007FEEB24CBDE8 00007FEEB24CBE48 4255 TM     5124    0     3       0  5455     0\r\n0000000C5A6A4860 0000000C5A6A48B8    1 AE      100    0     4       0 10323     0\r\n00007FEEB24CBDE8 00007FEEB24CBE48 1144 TM     5124    0     3       0   107     0\r\n0000000C5A6A9DD0 0000000C5A6A9E28 1144 TO     5124    2     3       0   107     0\r\n0000000C44D8FF08 0000000C44D8FF80 1144 TX 12845057 2063     6       0   107     0\r\n0000000C5A6AA4D0 0000000C5A6AA528 3405 AE      100    0     4       0  9547     0\r\n0000000C4F97CC28 0000000C4F97CCA0 3405 TX 12517398 2118     6       0  8543     0\r\n0000000C5A6A2278 0000000C5A6A22D0 3680 RS       25    1     2       0 10346     0\r\n0000000C5A6A3790 0000000C5A6A37E8 3963 TS       16    1     3       0  8906     0\r\n0000000C5A6AACC8 0000000C5A6AAD20 4255 AE      100    0     4       0  5484     0\r\n0000000C4FDC1288 0000000C4FDC1300 4255 TX 15073308 1757     6       0  5455     0\r\n0000000C5A6AA850 0000000C5A6AA8A8 1144 TO     5124    1     3       0  7441     0\r\n0000000C5A6A9338 0000000C5A6A9390 1420 TO     5124    2     3       0   840     0\r\n0000000C5A6A4940 0000000C5A6A4998 1983 KD        0    0     6       0 10324     0\r\n0000000C5A6A4B00 0000000C5A6A4B58 1983 KT    12540    0     4       0 10324     0\r\n0000000C5A6A2198 0000000C5A6A21F0 3680 CF        0    0     2       0 10350     0\r\n0000000C5A6A2438 0000000C5A6A2490 3397 RT        1    0     6       0 10346     0\r\n0000000C5A6A1E18 0000000C5A6A1E70 3680 XR        4    0     1       0 10350     0\r\n0000000C5A6A5F38 0000000C5A6A5F90 1134 AE      100    0     4       0   109     0\r\n0000000C5A6A4E80 0000000C5A6A4ED8 1420 AE      100    0     4       0  2824     0\r\n0000000C4FCAB578 0000000C4FCAB5F0 1420 TX 10223617 2128     6       0   840     0\r\n0000000C5A6A9EB0 0000000C5A6A9F08 1420 TO     5124    1     3       0   840     0\r\n0000000C5A6AA690 0000000C5A6AA6E8 4255 TO     5124    2     3       0  5455     0\r\n00007FEEB24CBDE8 00007FEEB24CBE48 1420 TM     5124    0     3       0   840     0\r\n0000000C5A6A6018 0000000C5A6A6070 1990 AE      100    0     4       0  1489     0\r\n0000000C5A6A4A20 0000000C5A6A4A78 2831 PW        1    0     3       0 10323     0\r\n0000000C5A6A1EF8 0000000C5A6A1F50 3680 RD        1    0     1       0 10350     0\r\n0000000C5A6AA5B0 0000000C5A6AA608 1144 AE      100    0     4       0  7459     0\r\n00007FEEB24CBDE8 00007FEEB24CBE48 3405 TM     5124    0     3       0  8543     0\r\n0000000C5A6A2518 0000000C5A6A2570 3963 TS        3    1     3       0 10325     0\r\n0000000C5A6AB128 0000000C5A6AB180 4255 TO     5124    1     3       0  5455     0\r\n33 rows selected.\r\nElapsed: 00:13:13.74<\/pre>\n<p>\u4e00\u4e2a\u5982\u6b64\u7b80\u5355\u7684\u67e5\u8be2\u6267\u884c\u65f6\u95f4\u5c45\u7136\u8d85\u8fc7\u4e8613\u5206\u949f\uff0c\u5728\u8fd9\u4e2aSQL\u8fd0\u884c\u8fc7\u7a0b\u4e2d\u68c0\u67e5\u53d1\u73b0\uff0c\u8fd9\u4e2a\u4f1a\u8bdd\u5728\u7b49\u5f85\u76f4\u63a5\u8def\u5f84\u5199\uff1a<\/p>\n<pre lang='SQL'>SQL> select sql_text from v$sql where sql_id in (select sql_id from v$Session where sid = 1420);\r\nSQL_TEXT\r\n--------------------------------------------------------------------------------------\r\nSELECT * FROM V$LOCK WHERE TYPE != :\"SYS_B_0\"\r\nSQL> select event, p1text, p1 from v$session where sid = 1420;\r\nEVENT                                    P1TEXT                  P1\r\n---------------------------------------- --------------- ----------\r\ndirect path write temp                   file number            201<\/pre>\n<p>\u68c0\u67e5\u4e86\u4e00\u4e0b\u6267\u884c\u8ba1\u5212\uff1a<\/p>\n<pre lang='SQL'>SQL> explain plan for\r\n  2  SELECT * FROM V$LOCK WHERE TYPE != 'MR';\r\nExplained.\r\nSQL> select * from table(dbms_XPlan.display);\r\nPLAN_TABLE_OUTPUT\r\n------------------------------------------------------------------------------------------------------------------------\r\nPlan hash value: 1899724433\r\n-------------------------------------------------------------------------------------\r\n| Id  | Operation              | Name       | Rows  | Bytes | Cost (%CPU)| Time     |\r\n-------------------------------------------------------------------------------------\r\n|   0 | SELECT STATEMENT       |            |     1 |   158 |     1 (100)| 00:00:01 |\r\n|*  1 |  HASH JOIN             |            |     1 |   158 |     1 (100)| 00:00:01 |\r\n|   2 |   MERGE JOIN CARTESIAN |            |     5 |   400 |     0   (0)| 00:00:01 |\r\n|*  3 |    FIXED TABLE FULL    | X$KSUSE    |     1 |    32 |     0   (0)| 00:00:01 |\r\n|   4 |    BUFFER SORT         |            |     5 |   240 |     0   (0)| 00:00:01 |\r\n|*  5 |     FIXED TABLE FULL   | X$KSQRS    |     5 |   240 |     0   (0)| 00:00:01 |\r\n|   6 |   VIEW                 | GV$_LOCK   |    10 |   780 |     0   (0)| 00:00:01 |\r\n|   7 |    UNION-ALL           |            |       |       |            |          |\r\n|*  8 |     FILTER             |            |       |       |            |          |\r\n|   9 |      VIEW              | GV$_LOCK1  |     2 |   156 |     0   (0)| 00:00:01 |\r\n|  10 |       UNION-ALL        |            |       |       |            |          |\r\n|* 11 |        FIXED TABLE FULL| X$KDNSSF   |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 12 |        FIXED TABLE FULL| X$KSQEQ    |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 13 |     FIXED TABLE FULL   | X$KTADM    |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 14 |     FIXED TABLE FULL   | X$KTATRFIL |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 15 |     FIXED TABLE FULL   | X$KTATRFSL |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 16 |     FIXED TABLE FULL   | X$KTATL    |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 17 |     FIXED TABLE FULL   | X$KTSTUSC  |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 18 |     FIXED TABLE FULL   | X$KTSTUSS  |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 19 |     FIXED TABLE FULL   | X$KTSTUSG  |     1 |   102 |     0   (0)| 00:00:01 |\r\n|* 20 |     FIXED TABLE FULL   | X$KTCXB    |     1 |   102 |     0   (0)| 00:00:01 |\r\n-------------------------------------------------------------------------------------\r\nPredicate Information (identified by operation id):\r\n---------------------------------------------------\r\n   1 - access(\"SADDR\"=\"S\".\"ADDR\" AND TO_CHAR(USERENV('INSTANCE'))||RAWTOHEX(\"\r\n              RADDR\")=TO_CHAR(\"R\".\"INST_ID\")||RAWTOHEX(\"R\".\"ADDR\"))\r\n   3 - filter(\"S\".\"INST_ID\"=USERENV('INSTANCE'))\r\n   5 - filter(\"R\".\"KSQRSIDT\"<>'MR')\r\n   8 - filter(USERENV('INSTANCE') IS NOT NULL)\r\n  11 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  12 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  13 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  14 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  15 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  16 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  17 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  18 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  19 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSOBFLG\",1)<>0)\r\n  20 - filter((\"KSQLKMOD\"<>0 OR \"KSQLKREQ\"<>0) AND\r\n              \"INST_ID\"=USERENV('INSTANCE') AND BITAND(\"KSSPAFLG\",1)<>0)\r\n56 rows selected.\r\nSQL> select count(*) from X$KSUSE;\r\n  COUNT(*)\r\n----------\r\n      4528\r\nSQL> select count(*) from X$KSQRS;\r\n  COUNT(*)\r\n----------\r\n     20144<\/pre>\n<p>\u663e\u7136\u5bfc\u81f4\u67e5\u8be2\u7f13\u6162\u4ee5\u53ca\u8bfb\u53d6\u4e34\u65f6\u7a7a\u95f4\u7684\u95ee\u9898\u539f\u56e0\u5728\u4e8e\u6267\u884c\u8ba1\u5212\u7684\u9519\u8bef\uff0c\u800c\u6267\u884c\u8ba1\u5212\u7684\u9519\u8bef\u5728\u4e8e\u7edf\u8ba1\u4fe1\u606f\u4e0d\u51c6\u786e\u3002<br \/>\n\u89e3\u51b3\u65b9\u6cd5\u6709\u4e24\u79cd\uff0c\u4e00\u79cd\u662f\u4f7f\u7528RBO\u8bfb\u53d6V$LOCK\u89c6\u56fe\uff0c\u53e6\u4e00\u79cd\u662f\u6536\u96c6V$\u89c6\u56fe\u7684\u7edf\u8ba1\u4fe1\u606f\uff0c\u662f\u7684Oracle\u83b7\u53d6\u6b63\u786e\u7684\u6267\u884c\u8ba1\u5212\uff1a<\/p>\n<pre lang='SQL'>SQL> select \/*+ rule *\/ * from v$lock where type != 'MR';\r\nADDR             KADDR             SID TY      ID1  ID2 LMODE REQUEST CTIME BLOCK\r\n---------------- ---------------- ---- -- -------- ---- ----- ------- ----- -----\r\n0000000C5A6A4A20 0000000C5A6A4A78 2831 PW        1    0     3       0  9861     0\r\n0000000C5A6A3790 0000000C5A6A37E8 3963 TS       16    1     3       0  8444     0\r\n0000000C5A6A2518 0000000C5A6A2570 3963 TS        3    1     3       0  9863     0\r\n00007FEEB24CC490 00007FEEB24CC4F0 1144 TM    75580    0     4       0  2615     0\r\n0000000C5A6A6E30 0000000C5A6A6E88 1144 AE        0    1     4       0  2615     0\r\n0000000C44D8FF08 0000000C44D8FF80 1144 TX 12124184 2594     6       0  2615     0\r\n00007FEEB24CC490 00007FEEB24CC4F0 1144 TM       28    0     3       0  2615     0\r\n0000000C5A6AA850 0000000C5A6AA8A8 1144 TO     5124    1     3       0  6979     0\r\n00007FEEB24CC490 00007FEEB24CC4F0 1144 TM    75584    0     4       0  2615     0\r\n0000000C5A6AA5B0 0000000C5A6AA608 1144 AE      100    0     4       0  6997     0\r\n0000000C5A6A6018 0000000C5A6A6070 1990 AE      100    0     4       0  1027     0\r\n0000000C5A6A4860 0000000C5A6A48B8    1 AE      100    0     4       0  9861     0\r\n0000000C5A6A4940 0000000C5A6A4998 1983 KD        0    0     6       0  9862     0\r\n0000000C5A6A4B00 0000000C5A6A4B58 1983 KT    12540    0     4       0  9862     0\r\n0000000C5A6AA770 0000000C5A6AA7C8 3405 TO     5124    2     3       0  8081     0\r\n00007FEEB24CC490 00007FEEB24CC4F0 3405 TM     5124    0     3       0  8081     0\r\n0000000C5A6AA4D0 0000000C5A6AA528 3405 AE      100    0     4       0  9085     0\r\n0000000C4F97CC28 0000000C4F97CCA0 3405 TX 12517398 2118     6       0  8081     0\r\n0000000C5A6AAA10 0000000C5A6AAA68 3405 TO     5124    1     3       0  8081     0\r\n0000000C5A6A2438 0000000C5A6A2490 3397 RT        1    0     6       0  9884     0\r\n0000000C4FDC1288 0000000C4FDC1300 4255 TX 15073308 1757     6       0  4993     0\r\n0000000C5A6AACC8 0000000C5A6AAD20 4255 AE      100    0     4       0  5022     0\r\n0000000C5A6AB128 0000000C5A6AB180 4255 TO     5124    1     3       0  4993     0\r\n0000000C5A6AA690 0000000C5A6AA6E8 4255 TO     5124    2     3       0  4993     0\r\n00007FEEB24CC490 00007FEEB24CC4F0 4255 TM     5124    0     3       0  4993     0\r\n0000000C5A6A9EB0 0000000C5A6A9F08 1420 TO     5124    1     3       0   378     0\r\n0000000C5A6A9338 0000000C5A6A9390 1420 TO     5124    2     3       0   378     0\r\n0000000C5A6A4E80 0000000C5A6A4ED8 1420 AE      100    0     4       0  2362     0\r\n00007FEEB24CC490 00007FEEB24CC4F0 1420 TM     5124    0     3       0   378     0\r\n0000000C4FCAB578 0000000C4FCAB5F0 1420 TX 10223617 2128     6       0   378     0\r\n0000000C5A6A1EF8 0000000C5A6A1F50 3680 RD        1    0     1       0  9888     0\r\n0000000C5A6A1E18 0000000C5A6A1E70 3680 XR        4    0     1       0  9888     0\r\n0000000C5A6A2198 0000000C5A6A21F0 3680 CF        0    0     2       0  9888     0\r\n0000000C5A6A2278 0000000C5A6A22D0 3680 RS       25    1     2       0  9884     0\r\n34 rows selected.\r\nElapsed: 00:00:00.17\r\nSQL> exec dbms_stats.gather_fixed_objects_stats\r\nPL\/SQL procedure successfully completed.\r\nElapsed: 00:04:03.17\r\nSQL> explain plan for\r\n  2  select * from v$lock where type != 'MR';\r\nExplained.\r\nElapsed: 00:00:00.20\r\nSQL> select * from table(dbms_xplan.display);\r\nPLAN_TABLE_OUTPUT\r\n---------------------------------------------------------------------------------------\r\nPlan hash value: 3524752130\r\n--------------------------------------------------------------------------------------\r\n| Id  | Operation               | Name       | Rows  | Bytes | Cost (%CPU)| Time     |\r\n--------------------------------------------------------------------------------------\r\n|   0 | SELECT STATEMENT        |            |   104K|    11M|    55 (100)| 00:00:01 |\r\n|   1 |  HASH JOIN              |            |   104K|    11M|    55 (100)| 00:00:01 |\r\n|   2 |   HASH JOIN             |            |   522 | 49068 |    43 (100)| 00:00:01 |\r\n|   3 |    VIEW                 | GV$_LOCK   |   522 | 40716 |    40 (100)| 00:00:01 |\r\n|   4 |     UNION-ALL           |            |       |       |            |          |\r\n|   5 |      FILTER             |            |       |       |            |          |\r\n|   6 |       VIEW              | GV$_LOCK1  |   207 | 16146 |    28 (100)| 00:00:01 |\r\n|   7 |        UNION-ALL        |            |       |       |            |          |\r\n|   8 |         FIXED TABLE FULL| X$KDNSSF   |     1 |    40 |     2 (100)| 00:00:01 |\r\n|   9 |         FIXED TABLE FULL| X$KSQEQ    |   206 |  8446 |    26 (100)| 00:00:01 |\r\n|  10 |      FIXED TABLE FULL   | X$KTADM    |   254 | 10160 |    10 (100)| 00:00:01 |\r\n|  11 |      FIXED TABLE FULL   | X$KTATRFIL |     1 |    36 |     0   (0)| 00:00:01 |\r\n|  12 |      FIXED TABLE FULL   | X$KTATRFSL |     1 |    36 |     0   (0)| 00:00:01 |\r\n|  13 |      FIXED TABLE FULL   | X$KTATL    |     1 |    54 |     0   (0)| 00:00:01 |\r\n|  14 |      FIXED TABLE FULL   | X$KTSTUSC  |     1 |    39 |     0   (0)| 00:00:01 |\r\n|  15 |      FIXED TABLE FULL   | X$KTSTUSS  |     1 |    39 |     0   (0)| 00:00:01 |\r\n|  16 |      FIXED TABLE FULL   | X$KTSTUSG  |     1 |    36 |     0   (0)| 00:00:01 |\r\n|  17 |      FIXED TABLE FULL   | X$KTCXB    |    55 |  2200 |     2 (100)| 00:00:01 |\r\n|  18 |    FIXED TABLE FULL     | X$KSUSE    |  4528 | 72448 |     2 (100)| 00:00:01 |\r\n|  19 |   FIXED TABLE FULL      | X$KSQRS    | 20093 |   431K|    10 (100)| 00:00:01 |\r\n--------------------------------------------------------------------------------------\r\n26 rows selected.\r\nElapsed: 00:00:00.06\r\nSQL> select * from v$lock where type != 'MR';\r\nADDR             KADDR             SID TY      ID1  ID2 LMODE REQUEST CTIME BLOCK\r\n---------------- ---------------- ---- -- -------- ---- ----- ------- ----- -----\r\n0000000C5A6A1E18 0000000C5A6A1E70 3680 XR        4    0     1       0 11480     0\r\n0000000C5A6A1EF8 0000000C5A6A1F50 3680 RD        1    0     1       0 11480     0\r\n0000000C5A6A2198 0000000C5A6A21F0 3680 CF        0    0     2       0 11480     0\r\n0000000C5A6A2438 0000000C5A6A2490 3397 RT        1    0     6       0 11476     0\r\n0000000C5A6A2278 0000000C5A6A22D0 3680 RS       25    1     2       0 11476     0\r\n0000000C4F97A3E8 0000000C4F97A460 1136 TX 15335430  878     6       0     0     0\r\n0000000C5A6A2518 0000000C5A6A2570 3963 TS        3    1     3       0 11455     0\r\n0000000C4FC26180 0000000C4FC261F8  569 TX 15007765 1622     6       0     0     0\r\n0000000C4FDBD628 0000000C4FDBD6A0 3682 TX 13107205 2166     6       0     0     0\r\n0000000C4FA02A30 0000000C4FA02AA8 2272 TX 14090252 2079     6       0     0     0\r\n0000000C5A6A4940 0000000C5A6A4998 1983 KD        0    0     6       0 11454     0\r\n0000000C5A6A4B00 0000000C5A6A4B58 1983 KT    12540    0     4       0 11454     0\r\n0000000C4FC23940 0000000C4FC239B8 1989 TX 10289157 2350     6       0     0     0\r\n0000000C5A6A4A20 0000000C5A6A4A78 2831 PW        1    0     3       0 11453     0\r\n0000000C5A6A9DD0 0000000C5A6A9E28 4258 AE      100    0     4       0   371     0\r\n0000000C5A6AACC8 0000000C5A6AAD20 4255 AE      100    0     4       0  6614     0\r\n0000000C5A6A68F0 0000000C5A6A6948 4251 AE      100    0     4       0   369     0\r\n.\r\n.\r\n.\r\n0000000C4FCAB578 0000000C4FCAB5F0 1421 TX 14417935 2082     6       0     0     0\r\n0000000C4FA8CEA8 0000000C4FA8CF20 3118 TX 13828121 2491     6       0     0     0\r\n0000000C4FA08ED0 0000000C4FA08F48 1420 TX 11730968 2288     6       0    41     0\r\n0000000C4FE47090 0000000C4FE47108 3965 TX 13369364 2318     6       0     0     0\r\n0000000C44E18550 0000000C44E185C8 2835 TX 13238301 2255     6       0     0     0\r\n0000000C4FCAC998 0000000C4FCACA10 1423 TX 10158112 2226     6       0     0     0\r\n0000000C44F291E0 0000000C44F29258  290 TX 12779538 2146     6       0     0     0\r\n519 rows selected.\r\nElapsed: 00:00:00.19<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5728Oracle 11.2.0.3 For Linux X64\u73af\u5883\u4e2d\uff0c\u78b0\u5230\u8fd9\u4e2a\u95ee\u9898\u3002 \u68c0\u67e5\u6570\u636e\u5e93\u662f\u5426\u5b58\u5728\u9501\u4fe1\u606f\uff0c\u5728\u67e5\u8be2V$LOCK\u89c6\u56fe\u65f6\u53d1\u73b0\u5f88\u957f\u65f6\u95f4\u6ca1\u6709\u54cd\u5e94\uff0c\u751a\u81f3\u4e00\u5ea6\u8ba4\u4e3a\u6570\u636e\u5e93HANG\u4f4f\uff1a SQL> select * from v$lock where type != &#8216;MR&#8217;; ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK &#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;- &#8212; &#8212;&#8212;&#8211; &#8212;- &#8212;&#8211; &#8212;&#8212;- &#8212;&#8211; &#8212;&#8211; 0000000C5A6AA770 0000000C5A6AA7C8 3405 TO 5124 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=693\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[255,571,572,570],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-bb","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/693"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=693"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/693\/revisions"}],"predecessor-version":[{"id":694,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/693\/revisions\/694"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}