ORA-00600 [Qsmqsetuptablemetadata-1] when Compiling a Materialized View (Doc ID 1133584.1)

Last updated on AUGUST 24, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

===  Issue Clarification ===

On production database 10.2.0.4 version, when attempting to compile a materialized view
alter materialized view "BRE_USER"."QS_FERNWAERME" compile;
the following error occurs.

ERROR
-----------------------
ORA-00600: Interner Fehlercode, Argumente: [qsmqSetupTableMetadata-1], [], [], [], [], [], [], []

When trying to drop this materialized view, it takes ages.
The mviews is listed as
.
SQL> SELECT obj#, NAME, TYPE# FROM OBJ$ WHERE obj# = 105225;
.
OBJ# NAME TYPE#
---------- ------------------------------ ----------
105225 QS_FERNWAERME 42
.
After tracing using 10046, the statement taking a lot of time is
.
select distinct sm.obj#, sm.containerobj#, sm.pflags, sm.xpflags, sm.mflags,
sq.hashval, sq.hashval2, sq.selcnt
from
sum$ sm, sumdetail$ sd, sumqb$ sq where sd.detailobj#=:1 and sd.sumobj#=
sm.obj# and sq.sumobj#=sd.sumobj# and sq.sumobj#=sm.obj# and sq.nodeid in
(0,1) and bitand(sm.pflags, 1073741824) = 0

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