今天早上巡检又见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 here for details of each of the sections below.
Affects:
Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions < 11Versions confirmed as being affected
10.2.0.4Platforms affectedGeneric (all / most platforms affected)
Fixed:
This issue is fixed in10.2.0.5 (Server Patch Set)
Symptoms:
Related To:
- Internal Error May Occur (ORA-600)ORA-600 [qerpxInitialize]
- Connect By / Hierarchical QueriesParallel Query (PQO)
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 symptomshere does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.
References
Bug:7308675 (This link will only work forPUBLISHED bugs)
Note:2458oracle账号40.1 Information on the sections in this article