ORA-00600 [5400] in parallel slave processes while doing insert into global temporary table (Doc ID 1507403.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

An insert statement, it is failing with ORA-00600 [5400]. You observe these internal errors in the parallel slave processes' tracefiles.

You may find some or all of the following function codes in the 'Call Stack' section of your trace file:

kdblba kdblGetBlockDba <- kdblgb <- kdblailb <- kdblai <- klclil1r
<- PGOSF766_qerltFRo <- PGOSF654_qeruaRow <- Procedure <- qertbFetch <- Procedure
<- qergiFetch <- rwsfcd <- qeruaFetch <- rwsfcd <- qerltFetch

The current sql statement shows you are doing parallel insert into global temporary table.

DBMS stats may also be running.

Changes

No recent changes.

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