parknkjun 发表于 2015-3-23 14:14:42

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

ORA-00600: internal error code, arguments: 请大家帮着看看。

Liu Maclean(刘相兵 发表于 2015-3-23 14:43:32

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

+ AIX

此类问题至少说明 数据库版本！

Liu Maclean(刘相兵 发表于 2015-3-23 14:46:43

相关SQL 语句：

SELECT NVL(SUM(NVL(HUB.AMOUNT, 0) * DECODE(HUB.CURRENCY_CODE, 'CNY', 1, CUX_GL_COMMON_PKG.GET_CONVERSION_RATE(P_FROM_CURRENCY_CODE => HUB.CURRENCY_CODE, P
_TO_CURRENCY_CODE => 'CNY', P_CONVERSION_TYPE => 'Corporate', P_CONVERSION_DATE => HUB.SALE_DATE))* (1+ZXB.PERCENTAGE_RATE/100)), 0) FROM CUX_AR_MOM_INVOI
CE_IF_HUB HUB, ZX_RATES_B ZXB

Liu Maclean(刘相兵 发表于 2015-3-23 14:47:09

CUX_AR_MOM_INVOI
CE_IF_HUB HUB, ZX_RATES_B ZXB
考虑对以上三张表做 analyze validate structure 验证

Liu Maclean(刘相兵 发表于 2015-3-23 14:47:32

@ kdsgrp1:
@
@  if (!bit(td->kdsbd.ktrdsflg, KCBDRCPT | KCBDUDBA))
@  {/*GENCOV:OTHER*/
@    kdsgrp1_dump(td, state, tbh);
@
@ It looks like it has been missed to set KCBDRCPT in kdsgrp before calling
@ kdsgrp1 when event 10231 is set in this call stack:
@
@ kdsgrp1 kdsgrp kdsgnp kafger qerixGetNonKeyCol qerixFetchIOTRangeScan

parknkjun 发表于 2015-3-23 14:53:33

多谢Maclean
页: [1]
查看完整版本: ORA-00600: internal error code, arguments: [kdsgrp1]