ORA-00600:[qkaPIdsqkn1] (Doc ID 2122372.1)

Last updated on APRIL 14, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Creating or refreshing materialized views, this fails with errors like below i the alert log:

Errors in file /sbRdbms/app/oracle/diag/rdbms/nwdshp/NWDSHp/trace/NWDSHp_j002_33554790.trc:
ORA-12012: Errore nell'esecuzione automatica dei lavori 1276
ORA-12008: errore nel percorso di aggiornamento della vista materializzata
ORA-00600: codice di errore interno, argomenti: [qkaPIdsqkn1], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: a "SYS.DBMS_SNAPSHOT", line 2809
ORA-06512: a "SYS.DBMS_SNAPSHOT", line 3025
ORA-06512: a "SYS.DBMS_IREFRESH", line 689
ORA-06512: a "SYS.DBMS_REFRESH", line 195
ORA-06512: a line 1


The trace file shows the current sql is an insert statement with a subquery with multiple joins.

Further information from the trace file shows:

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
700010d6fef3320 84 package body SYS.DBMS_SNAPSHOT
700010d6fef3320 2072 package body SYS.DBMS_SNAPSHOT
700010d6fef3320 2770 package body SYS.DBMS_SNAPSHOT
700010d6fef3320 3025 package body SYS.DBMS_SNAPSHOT
700010d7fd53c78 689 package body SYS.DBMS_IREFRESH
700010d9f9ee2c0 195 package body SYS.DBMS_REFRESH
7000102af52b858 1 anonymous block

----- Call Stack Trace -----

... qkaPIdsqkn qkajoi qkadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild ...

 

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