ORA-600 [15570]

Bug 8397251  OERI [15570] during parallel query

 This note gives a brief overview of bug 8397251. 
 The content was last updated on: 28-JUN-2013
 Click here for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 12.1
Versions confirmed as being affected	11.2.0.1 11.1.0.7 10.2.0.5 10.2.0.4
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

12.1.0.1 (Base Release) 11.2.0.2 (Server Patch Set) 11.2.0.1 Bundle Patch 4 for Exadata Database 11.2.0.1 Patch 8 on Windows Platforms

Symptoms:	Related To:
Internal Error May Occur (ORA-600) ORA-600 [15570]	Optimizer Parallel Query (PQO) _push_join_predicate Optimizer Join Push Predicate (JPPD)

Description

You may encounter ORA-600 [15570] during the execution of a parallel query
if the execution plan contains a view into which a join predicate has been
pushed.
 
Workarounds are:
set "_push_join_predicate"=FALSE;
or
use hint NO_PUSH_PRED
 

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. For questions about this bug please consult Oracle Support.

References

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