Solution to Oracle10g ORA-00600 Error

Source: Internet
Author: User
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

,

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.