Oracle 12.2 BUG :分区维护导致的 ORA-600 KKPOFPCD3

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

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

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

ORA-00600: internal error code, arguments: [kkpofpcd3], [], [], [], [], [], [], [], [], [], [], []

引发错误的SQL类似如下：

----- Current SQL Statement for this session (sql_id=c3zymn7x3k6wy) -----select obj#, dataobj#, part#, hiboundlen, hiboundval, flags, ts#, file#, block#, pctfree$, initrans, maxtrans, analyzetime, samplesize, rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, pctthres$, length(bhiboundval), bhiboundval from indpart$ where bo# = :1 order by part#[TOC00005]

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

========= Dump for incident 216417 (ORA 600 [kkpofpcd3]) ========[TOC00003]----- Beginning of Customized Incident Dump(s) -----fetched: partnum=0, dictnum=98, objn=63117  Owner              = 0  Name               = WRH$_FILESTATXS_PK  SubName            = WRH$_FILESTATXS_1263135530_266  objn_kkpacfrag     = 63117  objd_kkpacfrag     = 63117  tsn_kkpacfrag      = 1  dba_kkpacfrag      = 0x00000000  fragnum_kkpacfrag  = 0  dictnum_kkpacfrag  = 98  status_kkpacfrag   = 0x0  flags_kkpacfrag    = 0x0  fragtype_kkpacfrag = 0  hibnd_kkpacfrag    = "MAXVALUE, MAXVALUE"  bhibnd_kkpacfrag   : len=0, key=kkpodDumpOcd begin: hd=0ocd=7000101de49eba0    parttype_kkpacocd    = 1    subptype_kkpacocd    = 0    partcnt_kkpacocd     = 10    flags_kkpacocd       = 0x3    mflags_kkpacocd      = 0x0    status_kkpacocd      = 0x0    hidPartcnt_kkpacocd  = 0    hasSageTsn_kkpacocd  = 0    hasExadoopTsn_kkpaco = 0    noDMOffload_kkpacocd = 0    noDIDTSOffload_kkpac = 0    noXMLOffload_kkpacoc = 0    noJSONOffload_kkpaco = 0    noVGBYOffload_kkpaco = 0    partKCols_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=0    pcd=7000101de49f080, partnum=1, dictnum=10, objn=62637        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_0        objn_kkpacfrag     = 62637        objd_kkpacfrag     = 62637        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c17b12        fragnum_kkpacfrag  = 1        dictnum_kkpacfrag  = 10        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 30"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de49f218, partnum=2, dictnum=11, objn=62900        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_30        objn_kkpacfrag     = 62900        objd_kkpacfrag     = 62900        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c2489a        fragnum_kkpacfrag  = 2        dictnum_kkpacfrag  = 11        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 76"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de49f3b0, partnum=3, dictnum=13, objn=62901        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_76        objn_kkpacfrag     = 62901        objd_kkpacfrag     = 62901        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c248a2        fragnum_kkpacfrag  = 3        dictnum_kkpacfrag  = 13        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, MAXVALUE"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de49f550, partnum=4, dictnum=22, objn=63066        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_MXDB_MXSN        objn_kkpacfrag     = 63066        objd_kkpacfrag     = 63066        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c2806a        fragnum_kkpacfrag  = 4        dictnum_kkpacfrag  = 22        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 122"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de49f6e8, partnum=5, dictnum=33, objn=63076        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_122        objn_kkpacfrag     = 63076        objd_kkpacfrag     = 63076        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c2807a        fragnum_kkpacfrag  = 5        dictnum_kkpacfrag  = 33        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 146"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de49f880, partnum=6, dictnum=44, objn=63080        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_146        objn_kkpacfrag     = 63080        objd_kkpacfrag     = 63080        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c2870a        fragnum_kkpacfrag  = 6        dictnum_kkpacfrag  = 44        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 170"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de4a1468, partnum=7, dictnum=55, objn=63084        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_170        objn_kkpacfrag     = 63084        objd_kkpacfrag     = 63084        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c2871a        fragnum_kkpacfrag  = 7        dictnum_kkpacfrag  = 55        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 194"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de4a1600, partnum=8, dictnum=66, objn=63088        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_194        objn_kkpacfrag     = 63088        objd_kkpacfrag     = 63088        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c295ba        fragnum_kkpacfrag  = 8        dictnum_kkpacfrag  = 66        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 218"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de4a1798, partnum=9, dictnum=77, objn=63112        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_218        objn_kkpacfrag     = 63112        objd_kkpacfrag     = 63112        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c299a2        fragnum_kkpacfrag  = 9        dictnum_kkpacfrag  = 77        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 242"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0    pcd=7000101de4a1930, partnum=10, dictnum=88, objn=63116        Owner              = 0        Name               = WRH$_FILESTATXS_PK        SubName            = WRH$_FILESTATXS_1263135530_242        objn_kkpacfrag     = 63116        objd_kkpacfrag     = 63116        tsn_kkpacfrag      = 1        dba_kkpacfrag      = 0x00c299c2        fragnum_kkpacfrag  = 10        dictnum_kkpacfrag  = 88        status_kkpacfrag   = 0x0        flags_kkpacfrag    = 0x0        fragtype_kkpacfrag = 1        hibnd_kkpacfrag    = "1263135530, 266"        bhibnd_kkpacfrag   : len=0, key=        subpcnt_kkpacpcd   = 0        status_kkpacpcd    = 0kkpodDumpOcd end: hd=0

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

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

This bug is only relevant when using Partitioned TablesBrief Description:If you get ORA-600: [KKPOFPCD3] while doing merge partition online, then its likely that you have hit this bug. Rediscovery NotesIf you get ORA-600: [KKPOFPCD3] while doing merge partition online, then its likely that you have hit this bug. WorkaroundNONE