Parallel Query Against V$ Views Raises ORA-600[kokegPinLob1] (Doc ID 604462.1)

Last updated on JUNE 13, 2013

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

A parallel query executed against V$ views fails with the following error seen in the alert log:
   ORA-00600: internal error code, arguments: [kokegPinLob1], [], [], [], [], [], [], []

The call stack can look like this:
   kokegPinLob kokegCollectGarbage FromScalar kokegGarbageCollect ...

This error has been confirmed to affect at least the following V$ views:
   gv$sqlarea
   gv$session
   gv$px_session

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