Ora-00600[Qkaconfindpriorpred:1]

时间：2010-07-02 来源：fyuansheng

Ora-00600[Qkaconfindpriorpred:1] With Non-Default OPTIMIZER_INDEX_COST_ADJ [ID 759024.1]

	修改时间 01-JAN-2009 类型 PROBLEM 状态 REVIEWED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 11.1.0.7
This problem can occur on any platform.

Symptoms

The following error may occur when using the non-default value for OPTIMIZER_INDEX_COST_ADJ(default 100):

ORA-00600: internal error code, arguments: [qkaconFindPriorPred:1], [], [], [], [], [], [], []

Cause

Bug 5530235 - ORA-600 [QKACONFINDPRIORPRED:1] WITH NON-DEFAULT OPTIMIZER_INDEX_COST_ADJ

that was closed as a duplicate to

Bug:6282944 - Poor CONNECT BY performance with complex views
"CONNECTBY QPERF Details: A CONNECT BY query on a complex view that uses the filtering mode may get
a poor execution plan that shows that the CONNECT BY predicates are not used in the view.
Workaround: Sometimes forcing the use of the no-filtering mode can provide an improvement in
performance."

Solution

1- _optimizer_connect_by_cost_based=false
This is to switch off cost-based transformation for connect by clause, setting the parameter system wide may cause some performance degradation.
to set at session level:
alter session set "_optimizer_connect_by_cost_based"=false;

2-Use the default value for OPTIMIZER_INDEX_COST_ADJ(100)

3-Apply patch 6282944 , if the patch is not available for your platform please log a SR with Oracle Support.

The problem is fixed in the 11.1.0.7 patchset.