ORA-600 [kkpogrfp2] On A PCT Fast Refreshy Of a Materialized View (Doc ID 2065176.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

  1. Refreshing a materialized view using PCT and ATOMIC_REFRESH=FALSE results in:
    BEGIN DBMS_MVIEW.REFRESH(list=>'MEC_MV',method=>'P',atomic_refresh=>FALSE);
    END;

    *
    ERROR at line 1:
    ORA-12008: error in materialized view refresh path
    ORA-00600: internal error code, arguments: [kkpogrfp2], [4294967295], [0], [8], [], [], [], [], [], [], [], []
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2994
    ORA-06512: at line 1


  2. Review of the generated tracefiles reveals a call stack similar to:
    ... <- kkpogrfp_get_range_fragment_pre <- kkpogpffl_get_predicates_for_fr <- kkzgeuti_insgen <- kkzggeut <- kkzfrfeut <- kkzf_refresh_expr <- kkzpcbk <- opikkzprs1 <- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- opiall0 <- ...

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