ORA-00600 qerpxInitialize

kjut

今天早上巡检又见bug：

A select query using a connect-by clause executing using parallel query may fail with ORA-600 [qerpxInitialize].Bug 7308675  OERI:qerpxInitialize from parallel query using CONNECT BY

This note gives a brief overview of bug 7308675.

The content was last updated on: 27-MAY-2009

Click [url=]here[/url] for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions < 11
Versions confirmed as being affected	[url=]10.2.0.4[/url]
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

[url=]10.2.0.5 (Server Patch Set)[/url]

Symptoms:	Related To:
[url=]Internal Error May Occur (ORA-600)[/url] [url=]ORA-600 [qerpxInitialize][/url]	[url=]Connect By / Hierarchical Queries[/url] [url=]Parallel Query (PQO)[/url]

Description

A select query using a connect-by clause executing using  parallel query may fail with ORA-600 [qerpxInitialize].Workaround  Execute the query serially.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

References

Bug:7308675 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article