ORA-600 kcblasm_1和kghasp1错误

最近又是连续遇到bug。发现了两个规律，一是bug都是成群结队的出现，很少单独行动。二是bug一般都会出现在你比较忙的时候，手头的事情越是处理不过来，bug越来捣乱。

在一个产品库上又出现了ORA-600错误。第一个错误参数是kcblasm_1。这个sql语句后来又执行了一次，每次出错除了kcblasm_1外，还增加了kghasp1参数。

KCBLAMS_1错误的描述：

ERROR:
ORA-600 [kcblasm_1] [a]

VERSIONS:
versions 8.0 to 9.2

DESCRIPTION:

When allocating a new memory slot we perform some sanity checks on the
memory structures and find that something is wrong.

ARGUMENTS:
Arg [a] Error returned by kllcqas():
101 - KLLCQCME - can't allocate slot buffer memory
102 - KLLCQCAR - circular queue pointer invalid, slot structure
not intact, or slot already allocated
103 - KLLCQCCM - requested slot out of bounds (would exceed maximum
contiguous memory)

FUNCTIONALITY:
Kernel Cache Buffer Load management

IMPACT:
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

Have your hardware (especially CPU and memory) thoroughly checked.

If problem can be reproduced, upload trace files and testcase to
Oracle Support Services.

看来又是一个没有解决方案的bug。

检查SQL发现语句中包含了大量类似max(DECODE(a.type, '110', '产品说明书'))的语句，怀疑是这个引起的问题。

看来只能通过修改语句的写法来避开这个问题了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-69191/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-69191/