0

A simple query fails with the error. Has anyone faced this issue or has any solutions?

   SELECT MAX(some_value)
      FROM some_table
    WHERE some_id = 62328188199
       AND some_name = 'someParameter'
       AND someother_name = 'name';

ORA-00600: internal error code, arguments: [kksgaItLvl_Setup: desc], [3], [3], [], [], [], [], [], [], [], [], []

closed as off-topic by Colin 't Hart, hot2use, mustaccio, RDFozz, Md Haidar Ali Khan Sep 30 '18 at 3:54

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – hot2use, mustaccio, RDFozz, Md Haidar Ali Khan
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    ORA-00600 means "Fill out an SR with Oracle Support". These are internal bugs. Only Oracle can truly solve them. In most cases, the solution is "upgrade your database". In other cases, you'll need to rewrite the query. Someone might know the workaround. But, access to the official document requires a Support contract. – Michael Kutz Sep 27 '18 at 15:34
1

(Link accessible only by registration to Oracle Support):

Bug 21266085 - ORA-600 [kksgaItLvl_Setup: asc] from a query against an interval partitioned table (Doc ID 21266085.8)

The fix for 21266085 is first included in

12.2.0.1 (Base Release)
12.1.0.2.161018 (Oct 2016) Database Patch Set Update (DB PSU)
12.1.0.2.160719 (Jul 2016) Database Proactive Bundle Patch
11.2.0.4.160719 Exadata Database Bundle Patch (Jul 2016)
12.1.0.2.160419 (Apr 2016) Bundle Patch for Windows Platforms

Not the answer you're looking for? Browse other questions tagged or ask your own question.