Solution to Oracle10g ORA-00600 Error

ORA-00600: Internal error code, parameter: [19004], [], [], [], [], [], [], [], [], [], [], [] Error

ORA-00600: Internal error code, parameter: [19004], [], [], [], [], [], [], [], [], [], [], [] Error

Today, another colleague encountered an Oracle database bug:

-- This problem exists on all platforms in Oracle 10.1 OR 10.2.

<问题现像>
This error occurs when you perform complex multi-table join queries.
ORA-00600: Internal error code, parameter: [19004], [], [], [], [], [], [], []
Error

<解决办法>
This is an oracle bug.
Solution 1:
Run the following command as a DBA:
Execute dbms_stats.delete_schema_stats ('schema owner ');

Solution 2:
If only some tables have errors during query, you can only process the error table row.
Execute dbms_stats.delete_table_stats ('schema owner', 'table ');

The question is in English:

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies:
Oracle Server-Enterprise Edition-Version: 10.1 to 10.2
This problem can occur on any platform.

Symptoms
Alert log reports the following errors several times:
ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []

Trace file reports current SQL executed via SQLPlus which between des between aggregates and multijoins:
SELECT bill_rd_id_1_label, ultimate_orig_15_label, ultimate_orig_9_label, ultimate_orig_2_label, SUM (
VALUE_1 ),
SUM (VALUE_2), SUM (VALUE_3), SUM (VALUE_4), SUM (VALUE_5), SUM (VALUE_6), SUM (VALUE_7 ),
SUM (VALUE_8), SUM (VALUE_9), SUM (VALUE_10), SUM (VALUE_11), SUM (VALUE_12), SUM (VALUE_13), SUM (
VALUE_14), SUM (VALUE_15 ),.....

'2014-long log flat', '2014-plain and equp flat', '2014-heavy duty flat ', '2014-FRAME AND
Pedemo-flat ',
'2017-center beam flat ', '2017-other car type', '2017-bi level flat', '2017-tri level flat ', '2017
-Im conventional car (P )',
'2017-im articulated spine car (Q) ', '2017-trailers', '2017-ininers', '2017-TANK cart', '2017-
LOCOMOTIVE ', '2017-mow car ',
'2017-caboose', '2017-road railers and chasis ', '2017-im stack car (S)', '2017-WET ROCK
HOPPER ', 'unknown', 'unknown CAR_TYPE_3 ')
AND driver_cube_300.car_type_key = valid_car_type_300.car_type_key
AND driver_cube_300.bill_rd_id_key = valid_bill_rd_id_300.bill_rd_id_key
AND driver_cube_300.ultimate_orig_key = valid_ultimate_orig_300.ultimate_orig_key
AND driver_cube_300.lob_key = valid_lob_300.lob_key
AND driver_cube_300.time_key = valid_car_type_300.time_key
AND driver_cube_300.time_key = valid_bill_rd_id_300.time_key
AND driver_cube_300.time_key = valid_ultimate_orig_300.time_key
AND driver_cube_300.time_key = valid_lob_300.time_key
AND driver_cube_300.time_key = periods. time_key
AND driver_cube_300.time_key IN ('33', '34', '35 ')
Group by bill_rd_id_1_label, ultimate_orig_15_label, ultimate_orig_9_label, ultimate_orig_2_label
Order by bill_rd_id_1_label, ultimate_orig_15_label, ultimate_orig_9_label, ultimate_orig_2_label
Cause
Unpublished Bug 4899105-Multitable join cocould get ORA-600 [19004], if some of join columns have histograms.
Fixed In Ver: 11.0
Workaround:
Gather statistics without histograms

1. Stack (kkejeq kkepsl kkeidc kketac kkonxc kkotap) matches Bug 5041016 closed as duplicate of Bug 4899105.

2. Multitable join matches condition of internal Bug 4899105

Solution
1. Implement Workaround

Workaround:

Regather statistics without histograms

There is no way to only remove the histograms. You wocould need to re-collect statistics without the histograms.

Using dbms_stats package-you wowould spe

,