Parallel query fails with ORA-600 [15574] (Doc ID 2071937.1)

Last updated on OCTOBER 29, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

If a query is being run in parallel and has MIN or MAX or both types of expression over a
constant virtual column expression,then it may fail with ORA-600 [15574]

From corresponding trace file the failing query can be dtermined.As an example:

/*+ full(t) parallel(t,4) parallel_index(t,4) dbms_stats
cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring @ no_substrb_pad */@ to_char(count("UPDATE_TS")),
to_char(substrb(dump(min("UPDATE_TS"),16,0,32),1,120)),
to_char(substrb(dump(max("UPDATE_TS"),16,0,32),1,120)),
to_char(substrb(dump(min("MANDANT"),16,0,32),1,120)),
to_char(substrb(dump(max("INSERT_TS"),16,0,32),1,120))
from DWHCALL.HILF_WS_CALLS_TRFCALLS t



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