ORA-00600 [504]...[Mutex Stats] : SEEN FROM INSERT on WRH$_SQLSTAT (Doc ID 563069.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

The following symptoms will be seen :-

a) Following error or similar will be seen in alert log :-

ORA-00600: internal error code, arguments: [504], [0xC000000050228B20], [32], [0], [Mutex Stats],
[0], [2], [0x000000000]

[Mutex Stats] will need to be in the message for this article to be considered, it may solve other issues but is not written to do so.

b) ORA-600 trace will show SQL similar to what has been reported under <>

The SQL will need to be : INSERT into wrh$_sqlstat to be specifically linked to this article

c) The call stack in the trace file will be similar to :-

Function List (to Full stack) (to Summary stack)
ksedst <- ksedmp <- ksfdmp <- kgeriv <- kgesiv
<- ksesic7 <- ksl_level_check <- kslgetl <- ksl_get_child_latch <- kslgples <-
ksfgpl <- kgxWait <- kgxExclusive <- kqlfFillBindData <- kqlffc <- kqlfgo <- kgligo

d) The ORA600 trace file will report an 'Explain Plan' similar to :-

============
Plan Table
============
------------------------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
------------------------------------------------------------------+-----------------------------------+
| 0 | INSERT STATEMENT | | | | 1 | || 1 | NESTED LOOPS | | 100 | 181K | 0 | |
| 2 | FIXED TABLE FULL | X$KEWRSQLIDTAB | 100 | 800 | 0 | |
| 3 | FIXED TABLE FIXED INDEX | X$KGLCURSOR_CHILD_SQLIDPH (ind| 1 | 1844 | 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