My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_j002_33554790.trc:
ORA-12012: Errore nell'esecuzione automatica dei lavori 1276
ORA-12008: errore nel percorso di aggiornamento della 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 ...

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.