Parallel Query wrong result even after applying patch 22593668 and OPTIMIZER_FEATURE_ENABLE=18.104.22.168
(Doc ID 2290845.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
Query executed in parallel giving wrong result
Applying patch 22593668 didn't resolve issue
All hidden parameter workaround tried and no workaround was working for this case
alter session set "_slave_mapping_enabled" = false;
alter session set "_bloom_filter_enabled" = false;
alter session set "_bloom_pruning_enabled" = false;
alter session set "_bloom_predicate_enabled" = false;
alter session set "_push_join_union_view" = false;
alter session set "_optimizer_push_pred_cost_based" = false;
alter session set "optimizer_dynamic_sampling"=0;
Testcase available to check if you are hitting with same behaviour
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