2007. 1. 22. 09:18 오라클
ORA-00600 [kkqcby: qbcfkkc not zero] After Applying 10.2.0.2
Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 10.2.0.2
This problem can occur on any platform.
SymptomsThe following error is consistently appearing in the alert.log:
ORA-00600: internal error code, arguments: [kkqcby: qbcfkkc not zero], [], [], [], [], [], [], []
The Call Stack trace will include: kkqcbyCountJoinKeys kkqcbydrv qksqbApplyToQbcLoc
ChangesPatchset 10.2.0.2 has been applied.
Cause
This problem is due to unpublished Bug 4639977.
Solution
This bug fixed in 10.2.0.3 and 11i.
1. A one off patch exists for some 10.2.0.2 platforms on MetaLink:
Patch 4639977
-or-
2. The Workaround is to set the following parameter:
_optimizer_connect_by_cost_based = false
