ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600 kcblasm_1和kghasp1错误

ORA-600 kcblasm_1和kghasp1错误

原创 Linux操作系统 作者:yangtingkun 时间:2007-03-05 00:00:00 0 删除 编辑

最近又是连续遇到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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10486929