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:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
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
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 |
Changes |
Cause |
Solution |
References |