ORA-00600 [17089] while executing DROP MATERIALIZED VIEW (Doc ID 1383085.1)

Last updated on APRIL 06, 2020

Applies to:

Symptoms

• ORA-00600 [17089] occurs while dropping a Materialize View

ORA-00600: internal error code, arguments: [17089], [0x37E8DC110], [0x373825280], [], [], [], [], []
Current SQL statement for this session:
DROP MATERIALIZED VIEW "SYSTEM"."MV$$_00960001"

• The trace file confirms that this is caused by Access Advisor

*** 2011-12-09 19:21:29.965
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17089], [0x37E8DC110], [0x373825280], [], [], [], [], []
Current SQL statement for this session:
DROP MATERIALIZED VIEW "SYSTEM"."MV$$_00960001"
----- PL/SQL Call Stack -----
object line object
handle number name
0x37e93beb0 1142 package body SYS.PRVT_ACCESS_ADVISOR
0x37e93beb0 929 package body SYS.PRVT_ACCESS_ADVISOR
0x37e93c540 31 SYS.WRI$_ADV_SQLACCESS_ADV
0x380dcdb58 839 package body SYS.PRVT_ADVISOR
0x380dcdb58 4892 package body SYS.PRVT_ADVISOR
0x37e982e70 1 anonymous block

• The Call Stack confirms

kglupi qsmqddlk qsmqLockUnlockRefer encedTables qsmqSetupForDrop ...

Changes

Triggered by Access Advisor while executing package body SYS.PRVT_ACCESS_ADVISOR.

Cause

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