ORA-600[KKQSADJP-1] ERROR MESSAGES (Doc ID 551477.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

***Checked for relevance on 1-May-2013***

This error was observed on Oracle 10.2.0.3 64-bit on a HP-UX PA-RISC64-bit server.  It has been observed on earlier 10gR2 releases as well.

Symptoms:

- Users have errors when running queries.

- The Alert log can give this error: ORA-00600: internal error code, arguments: [kkqsadjp-1].    
The alert log can also give a simple ORA-7445

- The failing statement in the trace file is varied.  However, you can take the tables used in the failing SQL statement and search to see if there are Materialized views created on these tables. A list of materialized views can be obtained from dba_objects where object_type is 'MATERIALIZED VIEW'. If materialized views are created on  these tables, this is another indication of this bug.

- The error usually stops when query_rewrite_enabled = false

 

Call stack usually has function kkqsadjp at the top of the stack. e.g. :
ksedst ksedmp ksfdmp kgerinv kgeasnmierr
kkqsadjp kkqsgtjp kkqsgjpc kkqsJGCleanUpDropJo kkqsRTDrv kkqsbqjg kkqspsum
kkqsedrv kkqseqb

OR

ksedmp ssexhd sigacthandler
kkqsadjp kkqsdjgp kkqsbsjg kkqsechk kkqspsum kkqsedrv kkqseqb
kkqsrqb kkqsrmav kkqscqb kkqsptq kkqsptqur










Changes

If materialized views were recently created or refreshed, this may trigger the error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms