workaround:
To work around the problem:
either set "_and_pruning_enabled" = false
or
optimizer_features_enable='10.2.0.5'
You can do this e.g. at session level or via hint to the affected SQL.
e.g.
alter session|system set "_and_pruning_enabled" = false;
or
SELECT /*+ OPT_PARAM('_and_pruning_enabled' 'false') */ ...
To fix the problem upgrade to 12.1 or install patch 10097969 if available.
Niciun comentariu:
Trimiteți un comentariu