一大早接到报障,后台发现出现很多ORA-600 [kjbrchkpkeywait:timeout] 错误,该错误由insert插入分区表的sql引起。MOS上很多关于该类错误属于BUG的解析。
Note: For additional ORA-600 related information please read Note:146580.1 PURPOSE: This article represents a partially published OERI note. It has been published because the ORA-600 error has been reported in at least one confirmed bug. Therefore, the SUGGESTIONS section of this article may help in terms of identifying the cause of the error. This specific ORA-600 error may be considered for full publication at a later date. If/when fully published, additional information will be available here on the nature of this error. ERROR:
The list below is restricted to show only bugs believed to affect version 11.2.0.3.
Other bugs may affect this version but have not been confirmed as being relevant yet.There are 3 bugs listed.SUGGESTIONS: If the Known Issues section below does not help in terms of identifying a solution, please submit the trace files and alert.log to Oracle Support Services for further analysis. Known Issues:
NB Bug Fixed Description 14409183 11.2.0.3.4, 11.2.0.3.BP10, 11.2.0.4, 12.1.0.1 ORA-600 [kjblpkeydrmqscchk:pkey] or similar / session hangs on "gc buffer busy acquire" 14182835 11.2.0.3.BP14, 11.2.0.4, 12.1.0.1 Process fails with ORA-600 [kjbrchkpkeywait:timeout] 14043417 11.2.0.3.BP13, 11.2.0.4, 12.1.0.1 ORA-600 [kjbrchkpkeywait:timeout] in RAC - superseded
- '*' indicates that an alert exists for that issue.
- '+' indicates a particularly notable issue / bug.
- 'I' indicates an install issue / bug included for completeness.
- 'P' indicates a port specific bug.
- "OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].
You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/29225845/viewspace-775304/ ,如需转载,请注明出处,否则将追究法律责任。