| Ora-00600[Qkaconfindpriorpred:1] With Non-Default OPTIMIZER_INDEX_COST_ADJ [ID 759024.1] |
|
|
| |
修改时间 01-JAN-2009 类型 PROBLEM 状态 REVIEWED |
|
In this Document
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
- ORA-600 [QKACONFINDPRIORPRED:1] WITH NON-DEFAULT OPTIMIZER_INDEX_COST_ADJ
that was closed as a duplicate to
- 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 , 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.
References
- SLOW QUERY WITH INCREASED NUMBER OF ROWS
- ORA-00600 [QKACONFINDPRIORPRED:1] WITH NON-DEFAULT OPTIMIZER_INDEX_COST_ADJ
