Solve ORA-00600: internalerrorcode, arguments: [kcblasm_1], [1

Solve ORA-00600: internalerrorcode, arguments: [kcblasm_1], [103]

Solve ORA-00600: internal error code, arguments: [kcblasm_1], [103]

A ora-00600 error occurred on the production database a while ago, here the brief record analysis, if there is an error, I hope you give suggestions.

Error Message

ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []

The following information is available for viewing alarm logs:

View Zgscdb2_j003_14024898.trc

When executing a statement using a SELECT getting:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []

The execution plan from the ORA-600 trace file is showing hash join is used.

Call Stack is including:

Kcblasm1 kcblasm kxhfFndFreeSlot kxhfNewBuffer qerhjGetNewBuffer ksxb1bqb kxhrPack

Insert into BB_KJ_B00 WITH KJ_JZRQ_TEMP AS (select min (QC) QC, TO_DATE (: B2, 'yyyy-MM-DD ') QM,: B1 jg from KJ_JZRQ where kjnd = (SELE
Ct kjnd from KJ_JZRQ WHERE TO_DATE (: B2, 'yyyy-MM-DD ') between qc and qm) SELECT: B1 SJ_SWJG_DM, ZSXM_DM, SUM (SE) SE, SUM (ZYSE) ZY
SE, SUM (SSSE) SSSE, SUM (DSSE) DSSE, SUM (XQSE) XQSE, SUM (XZSE) XZSE, TO_DATE (: B2, 'yyyy-MM-DD ') BBQ, 'sql2' bz from (select. ZSXM_DM, SE
, A. ZYSE, A. SSSE, A. DSSE, A. XQSE, A. XZSE, RKRQ, D. SJ_SWJG_DM FROM nation A, KJ_JZRQ_TEMP B, DM_ZSXM C, KJ_ZW_HSDW D
A. Authorization = D. SS_SWJG_DM and a. ZSXM_DM = C. ZSXM_DM and d. SJ_SWJG_DM = B. jg and rkrq> = B. qc and rkrq <B. QM + 1 AND JKPZZL_DM
IN (SELECT PZZL_DM FROM DM_PZZL WHERE JKS_XYBZ = 'y' OR WSZ_XYBZ = 'y') union all select. ZSXM_DM,-SE,-. ZYSE,-. SSSE,-. DSSE,
-A. XQSE,-A. XZSE, THRQ, D. SJ_SWJG_DM FROM release A, KJ_JZRQ_TEMP B, DM_ZSXM C, mongod, DM_YSFPBL L WHERE A. SKSS_SWJ
G_DM = D. SS_SWJG_DM and d. SJ_SWJG_DM = B. jg and. YSFPBL_DM = L. YSFPBL_DM and. ZSXM_DM = C. ZSXM_DM and thrq> = B. qc and thrq <B. QM
+ 1) group by ZSXM_DM

This error is caused by the insert select statement of the extremely BT type. The database version is 10.2.0.5.

In 10.2.0.5, the patch P7612454 is used in all platform environments.
During join, the maximum Direct IO limit is 4096. We can see from the execution plan that the build of hash join is
The cardinality of the table is very large, which is the cause of this problem. The solution is as follows:
1. Version 11.2 solves the above problems
2. Upgrade the patch P7612454 to replace the kcbl. o file in lib.
3. If the execution plan is caused by hash join, set "_ hash_join_enable" in the Session Layer"
= False. If the execution plan is caused by hash group by, set "_ gby_hash_aggregation _
Enable "= false, in Execute immediate 'alter session set "_ hash_join_enabled" = false' before the corresponding SQL statement;

4. Modify the SQL statement to minimize the cardinality value of the build table.

Related materials on METALINK

Applies:
Oracle Server-Enterprise Edition-Version: 10.2.0.5.0 and later [Release: 10.2 and later]
Information in this document applies to any platform.

Symptoms
When executing a statement using a SELECT getting:
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], [], []
The execution plan from the ORA-600 trace file is showing hash join is used.
Call Stack is including:
Kcblasm1 kcblasm kxhfFndFreeSlot kxhfNewBuffer qerhjGetNewBuffer ksxb1bqb kxhrPack
Cause
The issue was investigated in:
Bug 9800302-10.2.0.5 GETTING ORA-00600 [KCBLASM_1]
Closed as duplicate of: Bug 7612454-Abstract: DSS: perf regressions in serial direct reads fixed in 11.2.
As per development team the number of slots available for direct I/OS (limited to 4096) forced the hash-join algorithm to operate on fewer number of slots and resulted in more spills to disk. this caused:
Direct path IO to perform worse in 10.2.0.5 than earlier releases with more "direct path read" operations or
ORA-600 [kcblasm_1] errors.

Solution
1. Upgrade the database to 11.2.
OR
2. apply & incFamilyProds = false & flag = search) "target = _ blank> Patch 7612454 available on MOS. if a patch is not currently available on top of your database version and/or platform please raise a Service Request to request for it.
Please be sure that your database version qualifies for getting a new patch as per Note 209768.1 and Note 742060.1.
OR
3. Use the workaround of setting:
"_ Hash_join_enabled" = false

References
BUG: 9781592-ORA-600 [KCBLASM_1] [103] DURING HASH JOIN QUERY USE ON DATABASE IN DWH
Bugs: 9800302-10.2.0.5 GETTING ORA-00600 [KCBLASM_1]
BUG: 9804132-insert fails with ORA-600 [KCBLASM_1], [103]
NOTE: 209768.1-Database, FMW, EM Grid Control, and OCS Software Error Correction Support Policy
NOTE: 742060.1-Release Schedule of Current Database Releases
NOTE: 7612454.8-Bug 7612454-More "direct path read" operations/OERI: kcblasm_1