ORA-00600[15735] When Querying A Table Whose Parallel Degree Is >1

(Doc ID 455202.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms



a) Alert will report ORA-00600[15735]
b) Trace file for the error will show a SELECT
c) select table_name, degree from dba_tables where table_name = '<name of table>';

This will show a degree >1

d) SELECT will work if table is altered as NOPARALLEL


e) The ORA-600 will contain information in the arguments that matches back to the database
parameter parallel_execution_message_size eg

The 2nd and 3rd arguments mean that we need a parallel_execution_message_size of 2176 but the limit of 2152 has been imposed by the init/spfile

The ORA-00600 trace will have a stack similar to :-

ksedmp kgeriv kgeasi kxfpcpmj kxfpg1sg kxfpgsg kxfrAllocSlaves kxfrialo kxfralo
qerpx_rowsrc_start qerpxStart qergsStart selexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main start

f) Or Import getting this error:ORA-00600: internal error code, arguments: [15735], [2240], [2152], [], [], [], [], [] with similar symptoms.

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