My Oracle Support Banner


Last updated on FEBRUARY 02, 2017

Applies to:

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


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

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


- 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


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


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


To view full details, 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 a vibrant support community of peers and Oracle experts.