My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2024

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 determined.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 <table name>t 



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.