Parallel Query wrong result even after applying patch 22593668 and OPTIMIZER_FEATURE_ENABLE=12.1.0.2 (Doc ID 2290845.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

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;

Changes

Testcase available to check if you are hitting with same behaviour

Cause

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