Reported By M00x And Shadow Processes

最新推荐文章于 2026-01-07 17:44:51 发布

转载最新推荐文章于 2026-01-07 17:44:51 发布 · 143 阅读

文章标签：

#数据库

本文详细介绍了如何解决Oracle数据库中遇到的ORA-00600错误，该错误由内存参数配置不当引起。通过移除手动设置的排序区大小、散列区大小，并修改工作区大小策略，最终成功解决了问题。

ORA-00600: internal error code, arguments: [kcblin_3], [103], [1040384], [8192], [8193], [312], [616], [], [], [], [], []

The issue was caused by a wrong database configuration related to memory parameters. There was implemented Automatic Memory Management of SGA and PGA through MEMORY_TARGET and in the same time there were set manual values for PGA workareas:

For example:
memory_target =
sort_area_size =
hash_area_size =
workarea_size_policy = "MANUAL"

In PFILE/SPFILE remove:

sort_area_size =
hash_area_size =
workarea_size_policy = "MANUAL"

and restart the instance with modified parameters file.

The manual values were ignored (even if set) but they caused ORA-600 [kcblin_3] errors.

Removing the above parameters fixed the errors.

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

转载于:http://blog.itpub.net/25223017/viewspace-710216/