My Oracle Support Banner

DBMS_MVIEW.REFRESH Fails with ORA-12008 ORA-600[kdzhchk - blk check failed] (Doc ID 2569630.1)

Last updated on MARCH 04, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Refreshing a materialized view fails as follows:

BEGIN DBMS_MVIEW.REFRESH('<MVIEW_NAME>','C',atomic_refresh=>false, parallelism=>16 ); END;

*
ERROR at line 1:
ORA-12008: error in materialized view or zonemap refresh path
ORA-00600: internal error code, arguments: [kdzhchk - blk check failed],
[6106], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 85
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 245
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2352
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2908
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3191
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3221
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 15
ORA-06512: at line 1

 

The associated incident trace file shows this Current SQL Statement:

/* MV_REFRESH (INS) */INSERT /*+ BYPASS_RECURSIVE_CHECK APPEND */ INTO "<OWNER>"."<TABLE_NAME>" ...

with this PL/SQL Call Stack:

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x176f154958 85 package body SYS.DBMS_SNAPSHOT_KKXRCA.REFRESH_KERNEL_INTERFACE
0x176f154958 245 package body SYS.DBMS_SNAPSHOT_KKXRCA.REFRESH_KERNEL_INTERFACE2
0x176f154958 2352 package body SYS.DBMS_SNAPSHOT_KKXRCA.SCHEDULE_AND_EXECUTE
0x176f154958 2908 package body SYS.DBMS_SNAPSHOT_KKXRCA.REFRESH_INTERNAL
0x176f154958 3191 package body SYS.DBMS_SNAPSHOT_KKXRCA.REFRESH_CEP
0x176f154958 3221 package body SYS.DBMS_SNAPSHOT_KKXRCA.REFRESH
0xd7db32538 15 package body SYS.DBMS_SNAPSHOT.REFRESH
0xce571e468 1 anonymous block

and this Call Stack Trace:

kdzhchk <- kdzhailseb <- kdzhcl <- kdzhbirc <- kdblai <- klclil1r <- qerltFRop <- qerpxFetch
 <- rwsfcd <- qerltFetch <- insdlexe <- insExecStmtExecIniEngine <- insexe <- opiexe
  <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- kprball
   <- kkzfrcParseAndExecute <- kkzfrc <- kkzfrsh_execute <- kkzfrsh <- kkzifr3g <- spefcmpa
    <- spefmccallstd <- peftrusted <- psdexsp <- kxe_push_env_internal_pp_
     <- kkx_push_env_for_ICD_for_new_session <- psdextp <- pefccal <- pefcal <- pevm_FCAL
      <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run

 

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
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.