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', '產品說明書'))的語句，懷疑是這個引起的問題。

看來只能透過修改語句的寫法來避開這個問題了。