Article Title, article title Daquan

Article Title, article title Daquan

Bug 4352808-Dump (kglpnal)/OERI: 17252/crash from PQ with TYPE columns (Document ID 4352808.8) go to the bottom

Bug 4352808 Dump (kglpnal)/OERI: 17252/crash from PQ with TYPE columns
This note gives a brief overview of bug 4352808.
The content was last updated on: 13-might-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 <10.1.0.2
Versions confirmed as being affected • 9.2.0.6
• 9.2.0.7

Platforms affected Generic (all/most platforms affected)
Fixed:
This issue is fixed in • 9.2.0.8 (Server Patch Set)

Symptoms: Related:
• Process May Dump (ORA-7445)/Abend/Abort
• Internal Error May Occur (ORA-600)
• Instance May Crash
• ORA-600 [17252]
• Dump in or under kglpnal
• Datatypes (Objects/Types/Collections)
• Parallel Query (PQO)

Description
Wrong slave SQL generation can occur for type columns
Where the slave SQL include "VALUE (table queue alias )"
Type SQL.
This can result in a dump in kglpnal in the PQ slave which
Can then be followed by an instance crash due to PMON aborting
With an ORA-600 [17252].

Workaround
Execute the problem SQL 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
Bugs: 4352808 (This link will only work for PUBLISHED bugs)
Note: 245840.1 Information on the sections in this article