DML Statements On Materialized View Triggers ORA-600 [Kgsccachehit] (Doc ID 801093.1)

Last updated on FEBRUARY 23, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.1.0.7 - Release: 9.2 to 11.1
Information in this document applies to any platform.

Symptoms

DML statements on materialized views may trigger following error on database.
ORA-00600: internal error code, arguments: [kgscCacheHit]

With a "Call Stack" similar to:
ksedst ksedmp ksedst ksfdmp kgerinv geasnmierr kgerinv kgscCacheHit kgeasnmierr kgscGetCursor kntxslt kntxit kxtrexe insart VInfreqinsLoadRow insrow insdrv inscovexe insExecStmtExecIniEngine insexe opiexe opiall0 opikpr opiodr rpidrus rpidru rpiswu2 kprball knipxin knipdis kporrcv knipdis kpostr opiodr ttcpip opitsk opiino opiodr opidrv sou2o

This behavior is generally seen on Windows Platform with Shared Server Configuration.

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