ORA-00600qerpxInitialize

ORA-00600qerpxInitialize

今天早上巡檢又見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 affected Versions < 11 Versions confirmed as being affected

• 10.2.0.4 Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

• 10.2.0.5 (Server Patch Set)

Symptoms:

Related To:

• Internal Error May Occur (ORA-600)
• ORA-600 [qerpxInitialize]
  • Connect By / Hierarchical Queries
  • Parallel 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 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