ORA-00600 [504]

操作系统：HP-UX B.11.31
硬件平台：Itanium 2 9100 （1.6G，18MB）
机器型号：IA64 HP Server rx8640

Oracle版本：9.2.0.8 64bit

ORA-00600: 内部错误代码，参数: [504], [0xC0000002788AD2E8], [640], [7], [shared pool], [3], [0], [0xC0000002788AD3D8]
ORA-00600: 内部错误代码，参数: [504], [0xC0000002788AD108], [160], [7], [shared pool], [1], [0], [0xC0000002788AD3D8]
ORA-00600: internal error code, arguments: [504], [0xC0000002788AD108], [1696], [7], [shared pool], [1], [0], [0xC0000002788AD3D8]
ORA-00600: 内部错误代码，参数: [504], [0xC0000002788AD1F8], [672], [7], [shared pool], [2], [0], [0xC0000002788AD3D8]
ORA-00600: internal error code, arguments: [504], [0xC0000002788AD108], [1184], [7], [shared pool], [1], [0], [0xC0000002788AD2E8]
ORA-00600: internal error code, arguments: [504], [0xC0000002788AD108], [676], [7], [shared pool], [1], [0], [0xC0000002788AD3D8]

原因：This is Bug 5888835 ORA-600 [504] DURING FLUSH SHARED_POOL closed as a duplicate of Base Bug 5508574 ORA-00600 [99999] , ORA-07445 [KGSCDUMP()+673]

The latch directory size exceeds 255 when _kgl_latch_count > 31.

However, even when the _kgl_latch_count is equal to 0 (default value), if the cpu_count is >=32 the bug still applies.

This is due to the as the _kgl_latch_count default value is calculated as next prime number after the value returned by cpu_count. So, this bug could still apply if the cpu_count=32 as the _kgl_latch_count would be calcuated to the next prime number would be 37.

解决方法：

1. Upgrade to the 10.2.0.4 patchset or the 11g release.
2. You can use workaround of setting parameter _kgl_latch_count <= 31 in your pfile/spfile.
3. Patch is available for your platform/version, download and apply Patch 5508574

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

转载于:http://blog.itpub.net/5359/viewspace-608402/