ORA-00600 [17089] While Dropping Materialized View Created By SQL Access Advisor (Doc ID 1457571.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

  1. The following error is raised while dropping a materialized view created by the SQL Access Advisor:
    *** ACTION NAME:(Auto-Purge Slave Action) 2012-01-10 23:00:33.760
    *** MODULE NAME:(MMON_SLAVE) 2012-01-10 23:00:33.760
    *** SERVICE NAME:(SYS$BACKGROUND) 2012-01-10 23:00:33.760
    *** SESSION ID:(975.9094) 2012-01-10 23:00:33.760
    *** 2012-01-10 23:00:33.760
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [17089], [0x1BA4FD710], [0x19F58B118], [], [], [], [], []
    Current SQL statement for this session:
    DROP MATERIALIZED VIEW "SYSTEM"."MV$$_1A26A0003"
    ----- PL/SQL Call Stack -----
     object      line  object
     handle    number  name
    000000019615C988      1158  package body SYS.PRVT_ACCESS_ADVISOR
    000000019615C988       929  package body SYS.PRVT_ACCESS_ADVISOR
    000000018FA9E268        31  SYS.WRI$_ADV_SQLACCESS_ADV
    00000001A1773B90       913  package body SYS.PRVT_ADVISOR
    00000001A1773B90      4989  package body SYS.PRVT_ADVISOR
    00000001A215D650         1  anonymous block


  2. Review of the generated tracefiles reveals a call stack similar to:
    ... <- kglupi <- qsmqddlk <- qsmqLockUnlockRefer <- encedTables <- qsmqSetupForDrop <- qsmqdsm <- kkzdsn <- opiexe <- ...

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