原文链接：https://www.modb.pro/db/23449?xy

在 Oracle 12.2 中，因为在线的分区合并、维护等工作导致了一个BUG的引入。

错误是 ORA-600 错误体现出来的，错误信息类似如下：

ORA-00600:internalerrorcode,arguments:[kkpofpcd3],[],[],[],[],[],[],[],[],[],[],[]

引发错误的SQL类似如下：

-----CurrentSQLStatementforthissession(sql_id=c3zymn7x3k6wy)-----selectobj#,dataobj#,part#,hiboundlen,hiboundval,flags,ts#,file#,block#,pctfree$,initrans,maxtrans,analyzetime,samplesize,rowcnt,blevel,leafcnt,distkey,lblkkey,dblkkey,clufac,pctthres$,length(bhiboundval),bhiboundvalfromindpart$wherebo#=:1orderbypart#[TOC00005]

关键的错误信息如下，核心是 Fetch Partnum DictNum 这部分：

=========Dumpforincident216417(ORA600[kkpofpcd3])========[TOC00003]-----BeginningofCustomizedIncidentDump(s)-----fetched:partnum=0,dictnum=98,objn=63117Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_266objn_kkpacfrag=63117objd_kkpacfrag=63117tsn_kkpacfrag=1dba_kkpacfrag=0x00000000fragnum_kkpacfrag=0dictnum_kkpacfrag=98status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=0hibnd_kkpacfrag="MAXVALUE,MAXVALUE"bhibnd_kkpacfrag:len=0,key=kkpodDumpOcdbegin:hd=0ocd=7000101de49eba0parttype_kkpacocd=1subptype_kkpacocd=0partcnt_kkpacocd=10flags_kkpacocd=0x3mflags_kkpacocd=0x0status_kkpacocd=0x0hidPartcnt_kkpacocd=0hasSageTsn_kkpacocd=0hasExadoopTsn_kkpaco=0noDMOffload_kkpacocd=0noDIDTSOffload_kkpac=0noXMLOffload_kkpacoc=0noJSONOffload_kkpaco=0noVGBYOffload_kkpaco=0partKCols_kkpacocd:colCnt=2[0]id=2,knl=2,dty=2,usr=2,csid=0,csform=0[1]id=1,knl=1,dty=2,usr=1,csid=0,csform=0pcd=7000101de49f080,partnum=1,dictnum=10,objn=62637Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_0objn_kkpacfrag=62637objd_kkpacfrag=62637tsn_kkpacfrag=1dba_kkpacfrag=0x00c17b12fragnum_kkpacfrag=1dictnum_kkpacfrag=10status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,30"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de49f218,partnum=2,dictnum=11,objn=62900Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_30objn_kkpacfrag=62900objd_kkpacfrag=62900tsn_kkpacfrag=1dba_kkpacfrag=0x00c2489afragnum_kkpacfrag=2dictnum_kkpacfrag=11status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,76"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de49f3b0,partnum=3,dictnum=13,objn=62901Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_76objn_kkpacfrag=62901objd_kkpacfrag=62901tsn_kkpacfrag=1dba_kkpacfrag=0x00c248a2fragnum_kkpacfrag=3dictnum_kkpacfrag=13status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,MAXVALUE"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de49f550,partnum=4,dictnum=22,objn=63066Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_MXDB_MXSNobjn_kkpacfrag=63066objd_kkpacfrag=63066tsn_kkpacfrag=1dba_kkpacfrag=0x00c2806afragnum_kkpacfrag=4dictnum_kkpacfrag=22status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,122"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de49f6e8,partnum=5,dictnum=33,objn=63076Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_122objn_kkpacfrag=63076objd_kkpacfrag=63076tsn_kkpacfrag=1dba_kkpacfrag=0x00c2807afragnum_kkpacfrag=5dictnum_kkpacfrag=33status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,146"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de49f880,partnum=6,dictnum=44,objn=63080Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_146objn_kkpacfrag=63080objd_kkpacfrag=63080tsn_kkpacfrag=1dba_kkpacfrag=0x00c2870afragnum_kkpacfrag=6dictnum_kkpacfrag=44status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,170"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de4a1468,partnum=7,dictnum=55,objn=63084Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_170objn_kkpacfrag=63084objd_kkpacfrag=63084tsn_kkpacfrag=1dba_kkpacfrag=0x00c2871afragnum_kkpacfrag=7dictnum_kkpacfrag=55status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,194"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de4a1600,partnum=8,dictnum=66,objn=63088Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_194objn_kkpacfrag=63088objd_kkpacfrag=63088tsn_kkpacfrag=1dba_kkpacfrag=0x00c295bafragnum_kkpacfrag=8dictnum_kkpacfrag=66status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,218"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de4a1798,partnum=9,dictnum=77,objn=63112Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_218objn_kkpacfrag=63112objd_kkpacfrag=63112tsn_kkpacfrag=1dba_kkpacfrag=0x00c299a2fragnum_kkpacfrag=9dictnum_kkpacfrag=77status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,242"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0pcd=7000101de4a1930,partnum=10,dictnum=88,objn=63116Owner=0Name=WRH$_FILESTATXS_PKSubName=WRH$_FILESTATXS_1263135530_242objn_kkpacfrag=63116objd_kkpacfrag=63116tsn_kkpacfrag=1dba_kkpacfrag=0x00c299c2fragnum_kkpacfrag=10dictnum_kkpacfrag=88status_kkpacfrag=0x0flags_kkpacfrag=0x0fragtype_kkpacfrag=1hibnd_kkpacfrag="1263135530,266"bhibnd_kkpacfrag:len=0,key=subpcnt_kkpacpcd=0status_kkpacpcd=0kkpodDumpOcdend:hd=0

这个问题对应的 BUG是：
Bug 25583657 ALTER TABLE MERGE PARTITIONS ONLINE MAY FAIL WITH ORA-600: [KKPOFPCD3]

这个 BUG 在 18.1 中被修正，官方的描述如下：
Description

ThisbugisonlyrelevantwhenusingPartitionedTablesBriefDescription:IfyougetORA-600:[KKPOFPCD3]whiledoingmergepartitiononline,thenitslikelythatyouhavehitthisbug.RediscoveryNotesIfyougetORA-600:[KKPOFPCD3]whiledoingmergepartitiononline,thenitslikelythatyouhavehitthisbug.WorkaroundNONE