My Oracle Support Banner

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

Last updated on MAY 20, 2021

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


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


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

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