{"id":1379,"date":"2013-07-10T23:54:07","date_gmt":"2013-07-10T15:54:07","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1379"},"modified":"2013-07-13T00:50:06","modified_gmt":"2013-07-12T16:50:06","slug":"ora-600ktrgcm_3%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1379","title":{"rendered":"ORA-600(ktrgcm_3)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623710.2.0.5 RAC\u6570\u636e\u5e93\u51fa\u73b0ORA-600[ktrgcm_3]\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Sun Jul 07 01:06:00 EAT 2013\r\nErrors in file \/oracle\/admin\/orcl\/udump\/orcl1_ora_28947.trc:\r\nORA-00600: internal error code, arguments: [ktrgcm_3], [], [], [], [], [], [], []<\/pre>\n<p>\u8be6\u7ec6TRACE\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>*** ACTION NAME:() 2013-07-07 00:49:57.500\r\n*** MODULE NAME:(g@orcl (TNS V1-V3)) 2013-07-07 00:49:57.500\r\n*** SERVICE NAME:(orcl) 2013-07-07 00:49:57.500\r\n*** SESSION ID:(3332.36419) 2013-07-07 00:49:57.500\r\n*** 2013-07-07 00:49:57.500\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [ktrgcm_3], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\nINSERT INTO T_B_T_IN (TRADE_ID,SUBSCRIBE_ID,BPM_ID,TRADE_TYPE_CODE,IN_MODE_CODE,PRIORITY,SUBSCRIBE_STATE, NEXT_DEAL_TAG,PRODUCT_ID,BRAND_CODE,USER_ID,CUST_ID,USECUST_ID,ACCT_ID,USER_DIFF_CODE, NET_TYPE_CODE,SERIAL_NUMBER,CUST_NAME,ACCEPT_DATE,ACCEPT_MONTH,TRADE_STAFF_ID, TRADE_DEPART_ID,TRADE_CITY_CODE,TRADE_EPARCHY_CODE,TERM_IP,EPARCHY_CODE,CITY_CODE, OLCOM_TAG,EXEC_TIME,FINISH_DATE,OPER_FEE,FOREGIFT,ADVANCE_PAY,INVOICE_NO,FEE_STATE, FEE_TIME,FEE_STAFF_ID,CANCEL_TAG,CANCEL_DATE,CANCEL_STAFF_ID,CANCEL_DEPART_ID, CANCEL_CITY_CODE,CANCEL_EPARCHY_CODE,CHECK_TYPE_CODE,CHK_TAG,AUDIT_TAG, AUDIT_BATCH_NO,ACTOR_NAME,ACTOR_CERTTYPEID,ACTOR_PHONE,ACTOR_CERTNUM, CONTACT,CONTACT_PHONE,CONTACT_ADDRESS,REMARK,IF_MAINTENANCE, PROVINCE_CODE,TRADE_PROVINCE_CODE,CANCEL_PROVINCE_CODE,RSRV_TAG1) SELECT A.TRADE_ID,SUBSCRIBE_ID,BPM_ID,TRADE_TYPE_CODE,IN_MODE_CODE,PRIORITY,SUBSCRIBE_STATE, NEXT_DEAL_TAG,A.PRODUCT_ID,NVL(D.BRAND_CODE,A.BRAND_CODE), A.USER_ID,A.CUST_ID,A.USECUST_ID,ACCT_ID,A.USER_DIFF_CODE, DECODE(A.PRODUCT_ID,'-1','99',NVL(D.NET_TYPE_CODE,A.NET_TYPE_CODE)),A.SERIAL_NUMBER,CUST_NAME,ACCEPT_DATE,A.ACCEPT_MONTH,TRADE_STAFF_ID, TRADE_DEPART_ID,TRADE_CITY_CODE,TRADE_EPARCHY_CODE,TERM_IP,A.EPARCHY_CODE,A.CITY_CODE, OLCOM_TAG,EXEC_TIME,FINISH_DATE,OPER_FEE,FOREGIFT,ADVANCE_PAY,INVOICE_NO,FEE_STATE, FEE_TIME,FEE_STAFF_ID, CASE WHEN B.TRADE_ID_A IS NOT NULL AND A.CANCEL_DATE IS NULL THEN DECODE(A.CANCEL_TAG,'0','4',A.CANCEL_TAG) ELSE CASE WHEN B.TRADE_ID_A IS NOT NULL AND TRUNC(A.ACCEPT_DATE,'DD')<TRUNC(A.CANCEL_DATE,'DD') THEN DECODE(A.CANCEL_TAG,'3','0',A.CANCEL_TAG) ELSE CASE WHEN TRUNC(A.ACCEPT_DATE,'DD')<TRUNC(A.CANCEL_DATE,'DD') THEN DECODE(A.CANCEL_TAG,'3','0',A.CANCEL_TAG) ELSE DECODE(A.CANCEL_TAG,'1','0','4','0',A.CANCEL_TAG) END END END CANCEL_TAG, CASE WHEN A.CANCEL_TAG IN ('1','4','3') AND TRUNC(A.ACCEPT_DATE,'DD')<TRUNC(A.CANCEL_DATE,'DD') THEN NULL ELSE A.CANCEL_DATE END CANCEL_DATE, CASE WHEN A.CANCEL_TAG IN ('1','4','3') AND TRUNC(A.ACCEPT_DATE,'DD')<TRUNC(A.CANCEL_DATE,'DD') THEN NULL ELSE A.CANCEL_STAFF_ID END CANCEL_STAFF_ID, CASE WHEN A.CANCEL_TAG IN ('1','4','3') AND TRUNC(A.ACCEPT_DATE,'DD')<TRUNC(A.CANCEL_DATE,'DD') THEN NULL ELSE A.CANCEL_DEPART_ID END CANCEL_DEPART_ID, CASE WHEN A.CANCEL_TAG IN ('1','4','3') AND TRUNC(A.ACCEPT_DATE,'DD')<TRUNC(A.CANCEL_DATE,'DD') THEN NULL ELSE A.CANCEL_CITY_CODE END CANCEL_CITY_CODE, CASE WHEN A.CANCEL_TAG IN ('1','4','3') AND TRUNC(A.ACCEPT_DATE,'DD')<TRUNC(A.CANCEL_DATE,'DD') THEN NULL ELSE A.CANCEL_EPARCHY_CODE END CANCEL_EPARCHY_CODE, CHECK_TYPE_CODE,CHK_TAG,AUDIT_TAG, AUDIT_BATCH_NO,ACTOR_NAME,ACTOR_CERTTYPEID,ACTOR_PHONE,ACTOR_CERTNUM, CONTACT,CONTACT_PHONE,CONTACT_ADDRESS,A.REMARK,IF_MAINTENANCE, F_SYS_GETVALUE('get_province_code',NULL,DECODE(LENGTH(A.EPARCHY_CODE),4,A.EPARCHY_CODE,A.TRADE_EPARCHY_CODE),NULL,NULL) PROVINCE_CODE, F_SYS_GETVALUE('get_province_code',NULL,A.TRADE_EPARCHY_CODE,NULL,NULL) TRADE_PROVINCE_CODE, F_SYS_GETVALUE('get_province_code',NULL,A.CANCEL_EPARCHY_CODE,NULL,NULL) CANCEL_PROVINCE_CODE, CASE WHEN C.NEW_STATE_CODE='H' THEN '9130' ELSE CASE WHEN C.OLD_STATE_CODE='H' THEN '9140' END END FROM TF_BH_TRADE A, (SELECT TRADE_ID_A,TRADE_ID_B FROM TF_B_TRADE_REL WHERE RELATION_TYPE_CODE='02' AND STATE IN ('0','A') )B,TF_B_TRADE_STATE_TRANS C,TD_B_PRODUCT D WHERE A.TRADE_ID=B.TRADE_ID_B(+) AND A.TRADE_ID=C.TRADE_ID(+) AND A.PRODUCT_ID = D.PRODUCT_ID(+) AND A.ACCEPT_MONTH = :B3 AND A.ACCEPT_DATE >= :B2 AND A.ACCEPT_DATE < :B1 AND A.TRADE_TYPE_CODE NOT IN ('116','616') AND A.NEXT_DEAL_TAG IN (SELECT VALUEC1 FROM TD_SD_COMMPARA WHERE PARAM_TYPE_CODE ='NEXT_DEAL_TAG') AND EXISTS (SELECT X.TRADE_ID FROM (SELECT B.TRADE_ID TRADE_ID FROM TF_B_TRADE_BATDEAL A,TF_BH_TRADE B WHERE A.TRADE_ID = B.TRADE_ID AND A.CANCEL_TAG = B.CANCEL_TAG AND A.STATE ='2' AND A.B_UPDATE_DATE >= :B2 AND A.B_UPDATE_DATE < :B1 AND A.BATCH_OPER_TYPE IN ('CREATEPREUSER','CREATEUSER','DISCNTCHG','ADDGRPMEMBER','BATREMOVEMEMBER','PRODUCTCHG','STATISTICS','BATCHARGEFEE','SCOREADJUST','CANCELPREUSER') MINUS SELECT TRADE_ID FROM T_B_T_IN ) X WHERE A.TRADE_ID = X.TRADE_ID)\r\n----- PL\/SQL Call Stack -----\r\n  object      line  object\r\n  handle    number  name\r\nc00000142951a9f8       434  procedure U_S_1.P_S_D_T_IN\r\nc0000013baacb568         1  anonymous block\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+64          call     ksedst1()            000000000 ? 000000001 ?\r\nksedmp()+2176        call     ksedst()             000000000 ?\r\n                                                   C000000000000D20 ?\r\n                                                   4000000004066EE0 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\nksfdmp()+112         call     ksedmp()             000000003 ?\r\n                                                   9FFFFFFFFFFE8EB0 ?\r\n                                                   60000000000BA288 ?\r\n                                                   9FFFFFFFFFFE9480 ?\r\n                                                   C000000000000999 ?\r\n                                                   40000000040AEF50 ?\r\nkgerinv()+304        call     ksfdmp()             9FFFFFFFFFFE9A10 ?\r\n                                                   000000003 ?\r\n                                                   9FFFFFFFFFFE9490 ?\r\n                                                   60000000000BA288 ?\r\n                                                   C000000000000612 ?\r\n                                                   4000000009903790 ?\r\nkgeasnmierr()+144    call     kgerinv()            60000000000318D0 ?\r\n                                                   4000000001AF87F0 ?\r\n                                                   6000000000032988 ?\r\n                                                   4000000001AF87F0 ?\r\n                                                   9FFFFFFFFFFE9A50 ?\r\n$cold_ktrgcm()+1188  call     kgeasnmierr()        60000000000318D0 ?\r\n8                                                  60000000003139F8 ?\r\n                                                   6000000000313A08 ?\r\n                                                   6000000000032D00 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   C0000014D3B02A54 ?\r\n                                                   C0000014BC6E8AEC ?\r\nktrget()+1088        call     $cold_ktrgcm()       9FFFFFFFBF349F60 ?\r\n                                                   60000000000BA288 ?\r\n                                                   C000000000000C1D ?\r\n                                                   4000000002FB1560 ?\r\n                                                   00003811B ?\r\nkdirfrs()+8160       call     ktrget()             9FFFFFFFBF349F60 ?\r\n                                                   000000000 ?\r\n                                                   C00000089B458014 ?\r\nqerixFetchFastFullS  call     kdirfrs()            9FFFFFFFBF349F58 ?\r\ncan()+7504                                         60000000000BA288 ?\r\n                                                   4000000003057DA0 ?\r\n                                                   00003825F ?\r\n                                                   9FFFFFFFBF34A070 ?\r\n                                                   00003821F ? 000000000 ?\r\n                                                   C000000000001430 ?\r\nqergiFetch()+816     call     qerixFetchFastFullS  C0000013CB1A0CA0 ?\r\n                              can()                4000000001CC4CE0 ?\r\n                                                   9FFFFFFFFFFEB750 ?\r\n                                                   000007FFF ? 000007FFF ?\r\n                                                   C0000013CB1A0CA0 ?\r\nrwsfcd()+256         call     qergiFetch()         C0000013CB1A08F8 ?\r\n                                                   4000000001CC4CE0 ?\r\n                                                   9FFFFFFFFFFEB750 ?\r\n                                                   000007FFF ?\r\nqerhjFetch()+912     call     rwsfcd()             9FFFFFFFBF34A698 ?\r\n                                                   4000000001CC4CE0 ?\r\n                                                   9FFFFFFFFFFEB750 ?\r\n                                                   000007FFF ?\r\nqerflFetch()+336     call     qerhjFetch()         C0000013CB1A0740 ?\r\n                                                   4000000001CCEC70 ?\r\n                                                   9FFFFFFFFFFEB820 ?\r\n                                                   000007FFF ?\r\nqersoFetch()+2080    call     qerflFetch()         C0000013CB1A05B0 ?\r\n                                                   4000000001CCEED0 ?\r\n                                                   C000001426EB7FA8 ?\r\n                                                   000007FFF ?\r\n                                                   60000000000BA288 ?\r\nqerseFetch()+400     call     qersoFetch()         C000001426EB7FA8 ?\r\n                                                   4000000001CCEBF0 ?\r\n                                                   9FFFFFFFFFFEB880 ?\r\n                                                   000007FFF ?\r\nqervwFetch()+368     call     qerseFetch()         C000001426EB7AE8 ?\r\n                                                   9FFFFFFFFFFEB8AC ?\r\n                                                   9FFFFFFFFFFEB8AC ?\r\n                                                   9FFFFFFFBF3DC5DA ?\r\nrwsfcd()+256         call     qervwFetch()         C000001426EB79C8 ?\r\n                                                   4000000001CC4CF0 ?\r\n                                                   9FFFFFFFFFFEB8D0 ?\r\n                                                   C000001426EB79C0 ?\r\nqerhjFetch()+1152    call     rwsfcd()             9FFFFFFFBF3DC5F8 ?\r\n                                                   4000000001CC4CF0 ?\r\n                                                   9FFFFFFFFFFEB8D0 ?\r\n                                                   000007FFF ?\r\nrwsfcd()+256         call     qerhjFetch()         C000001426EB7710 ?\r\n                                                   4000000001CC4D00 ?\r\n                                                   9FFFFFFFFFFEB9A0 ?\r\n                                                   000007FFF ?\r\nqerhjFetch()+1728    call     rwsfcd()             9FFFFFFFBF3DC800 ?\r\n                                                   4000000001CC4D00 ?\r\n                                                   9FFFFFFFFFFEB9A0 ?\r\n                                                   000007FFF ?\r\n                                                   60000000000BA288 ?\r\nqerjoFetch()+1168    call     qerhjFetch()         C0000013AB146D68 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000001 ?\r\n                                                   60000000000BA288 ?\r\n                                                   C0000000000012AB ?\r\nrwsfcd()+256         call     qerjoFetch()         C000001388B4B060 ?\r\n                                                   4000000001CCEC20 ?\r\n                                                   9FFFFFFFFFFEBA80 ?\r\n                                                   000007FFF ?\r\nqerhjFetch()+1728    call     rwsfcd()             9FFFFFFFBF3D7CA8 ?\r\n                                                   4000000001CC4D00 ?\r\n                                                   9FFFFFFFFFFEBAB0 ?\r\n                                                   000007FFF ?\r\n                                                   60000000000BA288 ?\r\nqerjoFetch()+1168    call     qerhjFetch()         C0000013FF4C97D0 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000001 ?\r\n                                                   60000000000BA288 ?\r\n                                                   C0000000000012AB ?\r\nqerflFetch()+336     call     qerjoFetch()         C000001380167980 ?\r\n                                                   4000000001CCEC70 ?\r\n                                                   9FFFFFFFFFFEBBC0 ?\r\n                                                   000000001 ?\r\nrwsfcd()+256         call     qerflFetch()         C0000013801676A0 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000001 ?\r\ninsfch()+304         call     rwsfcd()             9FFFFFFFBF3DAEF8 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000001 ?\r\ninsdrv()+912         call     insfch()             9FFFFFFFB9F46F60 ?\r\n                                                   C0000000000019BB ?\r\n                                                   60000000000BA288 ?\r\n                                                   40000000031630F0 ?\r\n                                                   00003821D ?\r\n                                                   60000000000C6FE0 ?\r\n                                                   60000000000C6F18 ?\r\n                                                   4000000001C116A0 ?\r\ninscovexe()+1408     call     insdrv()             9FFFFFFFFFFEC390 ?\r\n                                                   9FFFFFFFFFFEBBF0 ?\r\n                                                   60000000000BA288 ?\r\n                                                   40000000031B6160 ?\r\n                                                   00003825B ?\r\n                                                   9FFFFFFFFFFEBBF4 ?\r\ninsExecStmtExecIniE  call     inscovexe()          C0000013E1A08250 ?\r\nngine()+176                                        C0000013C3B02F08 ?\r\n                                                   9FFFFFFFFFFECB40 ?\r\ninsexe()+1040        call     insExecStmtExecIniE  C0000013E1A08250 ?\r\n                              ngine()              C0000013C3B02F08 ?\r\n                                                   9FFFFFFFFFFED3D0 ?\r\n                                                   60000000000BA288 ?\r\n                                                   C000000000000FA5 ?\r\n                                                   4000000003166C80 ?\r\nopiexe()+7760        call     insexe()             C0000013BE5AB8C0 ?\r\n                                                   9FFFFFFFFFFED3D0 ?\r\n                                                   9FFFFFFFFFFECB50 ?\r\n                                                   60000000000BA288 ?\r\n                                                   9FFFFFFFFFFED0D0 ?\r\n                                                   C0000000000025D3 ?\r\n                                                   4000000002F87610 ?\r\n                                                   00003821B ?\r\nopipls()+3680        call     opiexe()             9FFFFFFFFFFEED70 ?\r\n                                                   4000000003119420 ?\r\n                                                   60000000000C6CE0 ?\r\n                                                   9FFFFFFFFFFED0F0 ?\r\n                                                   60000000000BA288 ?\r\n                                                   00002DE7D ?\r\n                                                   C00000000000224C ?\r\n                                                   001121800 ?\r\nopiodr()+2144        call     opipls()             9FFFFFFFFFFEF680 ?\r\n                                                   4000000002F58A60 ?\r\n                                                   00002E0B7 ?\r\n                                                   9FFFFFFFFFFEEDD0 ?\r\n                                                   60000000000BA288 ?\r\n                                                   000000001 ?\r\nrpidrus()+368        call     opiodr()             000000066 ? 000000006 ?\r\n                                                   4000000001C14510 ?\r\n                                                   0000046C0 ?\r\n                                                   9FFFFFFFFFFEF690 ?\r\n                                                   60000000000BA288 ?\r\nskgmstack()+288      call     rpidrus()            9FFFFFFFFFFF1DD0 ?\r\n                                                   9FFFFFFFFFFF1810 ?\r\n                                                   60000000000BA288 ?\r\n                                                   9FFFFFFFFFFF1D90 ?\r\n                                                   C000000000000716 ?\r\n                                                   4000000002F92F80 ?\r\n                                                   00002E07F ?\r\n                                                   9FFFFFFFFFFF1870 ?\r\nrpidru()+240         call     skgmstack()          9FFFFFFFFFFF1DF0 ?\r\n                                                   6000000000030F50 ?\r\n                                                   00000F618 ?\r\n                                                   4000000001CCBAD0 ?\r\n                                                   9FFFFFFFFFFF1DD0 ?\r\nrpiswu2()+976        call     rpidru()             00000057B ?\r\n                                                   C000000000001026 ?\r\n                                                   C000000000001026 ?\r\n                                                   4000000002F8FD10 ?\r\n                                                   9FFFFFFFFFFF1DE8 ?\r\n                                                   9FFFFFFFFFFF2C10 ?\r\nrpidrv()+2352        call     rpiswu2()            9FFFFFFFFFFF2B00 ?\r\n                                                   4000000002F92360 ?\r\n                                                   00002F933 ?\r\n                                                   9FFFFFFFFFFF2590 ?\r\n                                                   60000000000329A8 ?\r\n                                                   C000000000001ABD ?\r\n                                                   4000000000F32248 ?\r\n                                                   60000000000C6CE0 ?\r\npsddr0()+464         call     rpidrv()             000000008 ? 000000066 ?\r\n                                                   9FFFFFFFFFFF3710 ?\r\n                                                   000000038 ?\r\n                                                   9FFFFFFFFFFF2B30 ?\r\n                                                   60000000000BA288 ?\r\npsdnal()+736         call     psddr0()             000000008 ? 000000066 ?\r\n                                                   9FFFFFFFFFFF3710 ?\r\n                                                   000000030 ?\r\npevm_EXECC()+832     call     psdnal()             9FFFFFFFFFFF54E0 ?\r\n                                                   C0000014FF9104E0 ?\r\n                                                   C0000000000011AA ?\r\n                                                   9FFFFFFFBF3D3060 ?\r\n                                                   C00000142951A9F8 ?\r\n                                                   4000000003159470 ?\r\n                                                   00002C835 ?\r\npfrinstr_EXECC()+16  call     pevm_EXECC()         9FFFFFFFBF3D9F40 ?\r\n0                                                  9FFFFFFFBF3D30D0 ?\r\n                                                   000000020 ?\r\npfrrun_no_tool()+19  call     pfrinstr_EXECC()     9FFFFFFFBF3D9F40 ?\r\n2                                                  C0000013A9EE034C ?\r\n                                                   9FFFFFFFBF3D9FA8 ?\r\npfrrun()+1376        call     pfrrun_no_tool()     9FFFFFFFBF3D9F40 ?\r\n                                                   000002001 ?\r\n                                                   9FFFFFFFBF3D9FA8 ?\r\n                                                   60000000000BA288 ?\r\n                                                   C000000000000A1C ?\r\n                                                   4000000003180540 ?\r\n                                                   9FFFFFFFBF3DA390 ?\r\n                                                   9FFFFFFFBF3DA008 ?\r\nplsql_run()+1328     call     pfrrun()             9FFFFFFFFFFF3798 ?\r\n                                                   9FFFFFFFFFFF3780 ?\r\n                                                   60000000000BA288 ?\r\n                                                   9FFFFFFFFFFF4380 ?\r\n                                                   9FFFFFFFFFFF4380 ?\r\n                                                   C000000000000E23 ?\r\n                                                   4000000002C52D50 ?<\/pre>\n<p>\u6839\u636eMOS\u6587\u6863\uff0cORA-600[ktrgcm_3]\u5b58\u5728\u4e09\u4e2a\u5df2\u77e5bug\uff0c\u5176\u4e2d\u548cBug 7225204 - OERI [ktrgcm_3] can occur [ID 7225204.8]\u7684\u63cf\u8ff0\u975e\u5e38\u76f8\u4f3c\uff0c\u5f53\u524d\u62a5\u9519\u7684SQL\u8bed\u53e5\u5c31\u662fINSERT SELECT\u8bed\u53e5\uff0c\u4e14INSERT\u5bf9\u5e94\u7684\u8868\u5728SELECT\u4e2d\u4e5f\u4f1a\u51fa\u73b0\uff0c\u8fd9\u4e0eBUG\u7684\u63cf\u8ff0\u5b8c\u5168\u4e00\u81f4\u3002<br \/>\n\u89c2\u5bdf\u9519\u8bef\u8bed\u53e5\u7684\u6267\u884c\u8ba1\u5212\uff1a<\/p>\n<pre lang='SQL'>============\r\nPlan Table\r\n============\r\n---------------------------------------------------------------------+----------------------\r\n| Id | Operation                                | Name               | Rows | Bytes | Cost |\r\n---------------------------------------------------------------------+----------------------\r\n| 0  | INSERT STATEMENT                         |                    |      |       | 618K |\r\n| 1  |  FILTER                                  |                    |      |       |      |\r\n| 2  |   NESTED LOOPS SEMI                      |                    |    1 |   345 | 618K |\r\n| 3  |    HASH JOIN OUTER                       |                    |    1 |   326 | 618K |\r\n| 4  |     NESTED LOOPS OUTER                   |                    |    1 |   301 | 618K |\r\n| 5  |      HASH JOIN OUTER                     |                    |    1 |   282 | 618K |\r\n| 6  |       HASH JOIN SEMI                     |                    |    1 |   263 | 618K |\r\n| 7  |        PARTITION RANGE SINGLE            |                    |   16 |  4000 |    4 |\r\n| 8  |         TABLE ACCESS BY LOCAL INDEX ROWID| TF_BH_TRADE        |   16 |  4000 |    4 |\r\n| 9  |          INDEX RANGE SCAN                | IDX_TF_BH_TRADE_ACC|    1 |       |    3 |\r\n| 10 |        VIEW                              |                    |  13K |  169K | 618K |\r\n| 11 |         MINUS                            |                    |      |       |      |\r\n| 12 |          SORT UNIQUE                     |                    |  13K |  534K |      |\r\n| 13 |           FILTER                         |                    |      |       |      |\r\n| 14 |            HASH JOIN                     |                    |  13K |  534K | 617K |\r\n| 15 |             TABLE ACCESS FULL            | TF_B_TRADE_BATDEAL |  13K |  377K | 441K |\r\n| 16 |             PARTITION RANGE ALL          |                    | 172M | 2063M | 174K |\r\n| 17 |              INDEX FAST FULL SCAN        | PK_TF_BH_TRADE     | 172M | 2063M | 174K |\r\n| 18 |          SORT UNIQUE                     |                    | 260K | 2599K |      |\r\n| 19 |           INDEX FAST FULL SCAN           | IDX_T_B_T_ID       | 260K | 2599K |  231 |\r\n| 20 |       TABLE ACCESS FULL                  | TF_B_T_STATE_TRANS |    1 |    19 |    2 |\r\n| 21 |      TABLE ACCESS BY INDEX ROWID         | TD_B_PRODUCT       |    1 |    19 |    2 |\r\n| 22 |       INDEX UNIQUE SCAN                  | PK_TD_B_PRODUCT    |    1 |       |    1 |\r\n| 23 |     TABLE ACCESS FULL                    | TF_B_TRADE_REL     | 116K | 2888K |  169 |\r\n| 24 |    TABLE ACCESS BY INDEX ROWID           | TD_SD_COMMPARA     |    8 |   152 |    2 |\r\n| 25 |     INDEX RANGE SCAN                     | PK_TD_SD_COMMPARA  |    8 |       |    1 |\r\n---------------------------------------------------------------------+----------------------<\/pre>\n<p>\u914d\u5408\u62a5\u9519\u51fd\u6570\u4fe1\u606f\uff0c\u4e0d\u96be\u786e\u8ba4\uff0c\u95ee\u9898\u53d1\u751f\u5728\u5bf9T_B_T_IN\u8868\u7684\u7d22\u5f15\u5feb\u901f\u5168\u626b\u63cf\u4e0a\u3002<br \/>\n\u4f46\u662f\u8fd9\u4e2a\u9519\u8bef\u5f71\u54cd10.2.0.4\u548c11.1.0.7\uff0cOracle\u572810.2.0.5\u4e2d\u5e94\u8be5\u5df2\u7ecf\u4fee\u6b63\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002\u89c2\u5bdf\u6587\u6863Bug 6157713 - Wrong result from ORA_ROWSCN [ID 6157713.8]\u7684\u63cf\u8ff0\uff0c\u867d\u7136\u7248\u672c\u4fe1\u606f\u7b26\u5408\uff0c\u4f46\u662f\u5f53\u524d\u5e76\u6ca1\u6709\u8c03\u7528ORA_ROWSCN\u4f2a\u5217\uff0c\u4e0d\u8fc7\u8fd9\u4e2aBUG\u7684\u63cf\u8ff0\u4e2d\uff0c\u53c8\u6307\u5411\u4e86\u4e0a\u97627225204\u7684bug\u3002<br \/>\n\u6700\u540e\u68c0\u67e5\u6587\u6863Bug 14076510 - ORA-600 [ktrgcm_3] in 10.2.0.5.3 - 10.2.0.5.7 [ID 14076510.8]\uff0c\u53ef\u4ee5\u770b\u5230\u8fd9\u4e2abug\u63cf\u8ff0\u572810.2.0.5.3\u4e4b\u540e\u51fa\u73b0\u7684ktrgcm_3\u9519\u8bef\u7684\u539f\u56e0\uff0c\u6839\u636e\u4e09\u7bc7\u6587\u7ae0\u7684\u63cf\u8ff0\uff0c\u4ee5\u53ca\u5f53\u524d\u7684\u73b0\u8c61\uff0c\u611f\u89c9\u4e09\u7bc7\u6587\u6863\u63cf\u8ff0\u7684\u5e94\u8be5\u662f\u90fd\u4e00\u4e2abug\uff0cOracle\u5728\u5904\u7406\u81ea\u5173\u8054\u67e5\u8be2\u65f6\u5f15\u53d1\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002\u800c\u8fd9\u4e2abug\u5e76\u6ca1\u6709\u572810.2.0.5\u4e2d\u88ab\u771f\u6b63\u4fee\u590d\u3002<br \/>\n\u9664\u4e86\u5347\u7ea7\u523010.2.0.5.8\u4ee5\u53ca11.2\u5916\uff0c\u5982\u679c\u53ef\u80fd\uff0c\u4fee\u6539\u8bed\u53e5\u907f\u514dINSERT SELECT\u8bed\u53e5\u8bbf\u95ee\u63d2\u5165\u8868\u3002\u6b64\u5916Oracle\u8fd8\u63d0\u4f9b\u4e86\u8bbe\u7f6e\u9690\u542b\u53c2\u6570\"_row_cr\"\u4e3aFALSE\u7684\u65b9\u5f0f\uff0c\u8fd9\u79cd\u65b9\u5f0f\u4f1a\u5e26\u6765\u6027\u80fd\u7684\u5f71\u54cd\uff0c\u5982\u679c\u8fd9\u4e2a\u9519\u8bef\u9891\u7e41\u53d1\u751f\uff0c\u4e5f\u53ef\u4ee5\u8003\u8651\u8fdb\u884c\u8bbe\u7f6e\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623710.2.0.5 RAC\u6570\u636e\u5e93\u51fa\u73b0ORA-600[ktrgcm_3]\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Sun Jul 07 01:06:00 EAT 2013 Errors in file \/oracle\/admin\/orcl\/udump\/orcl1_ora_28947.trc: ORA-00600: internal error code, arguments: [ktrgcm_3], [], [], [], [], [], [], [] \u8be6\u7ec6TRACE\u5982\u4e0b\uff1a *** ACTION NAME:() 2013-07-07 00:49:57.500 *** MODULE NAME:(g@orcl (TNS V1-V3)) 2013-07-07 00:49:57.500 *** &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1379\">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":[5],"tags":[1211,262,1209,8,1210],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-mf","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1379"}],"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=1379"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1379\/revisions"}],"predecessor-version":[{"id":1380,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1379\/revisions\/1380"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}