ORA-600 [Kksfbc-Bad-Unpin] On Explain Plan (Doc ID 746220.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.1.0.5
This problem can occur on any platform.

Symptoms

The following error occurs daily in the database alert log file:
    ORA-00600: internal error code, arguments: [kksfbc-bad-unpin], [], [], [], [], [], [], []

In the trace file is not reported any failing statement but if we check the current cursor, we find:

   EXPLAIN PLAN SET STATEMENT_ID = <id> INTO <table name> FOR
    <here goes the sql statement>

The Call Stack looks like:
     kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr ttcpip opitsk opiino opiodr

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