文章标题，文章标题大全
Bug 4352808 - Dump (kglpnal) / OERI:17252 / crash from PQ with TYPE columns (文档 ID 4352808.8) 转到底部
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-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 < 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 To:
• 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
Bug:4352808 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article