通过调整参数或者安装补丁可以解决该问题。
1.相关参数设置
alter session set "_pred_move_around"=FALSE;
2.补丁修复
补丁修复该bug参考了客户exadata环境。
Exadata环境Patch分析说明:
Patch 21761335 : applied on Wed Dec 16 22:19:07 CST 2015
Unique Patch ID: 19326074
Patch description: "DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20) : (21761335)"
Created on 21 Sep 2015, 01:49:45 hrs PST8PDT
Sub-patch 21637587; "DATABASE PATCH FOR EXADATA (Sep2015 - 11.2.0.4.19) : (21637587)"
Sub-patch 21439740; "DATABASE PATCH FOR EXADATA (AUG2015 - 11.2.0.4.18) : (21439740)"
Sub-patch 21025821; "DATABASE PATCH FOR EXADATA (JUL2015 - 11.2.0.4.17) : (21025821)"
Sub-patch 20449729; "DATABASE PATCH FOR EXADATA (APR2015 - 11.2.0.4.16) : (20449729)"
Sub-patch 20059375; "DATABASE PATCH FOR EXADATA (JAN2015 - 11.2.0.4.15) : (20059375)"
Sub-patch 19893780; "DATABASE PATCH FOR EXADATA (Dec2014 - 11.2.0.4.14) : (19893780)"
Sub-patch 19698715; "DATABASE PATCH FOR EXADATA (Nov2014 - 11.2.0.4.13) : (19698715)"
Sub-patch 19495869; "DATABASE PATCH FOR EXADATA (OCT2014 - 11.2.0.4.12) : (19495869)"
Sub-patch 19307276; "DATABASE PATCH FOR EXADATA (SEP2014 - 11.2.0.4.11) : (19307276)"
Sub-patch 19061859; "DATABASE PATCH FOR EXADATA (AUG2014 - 11.2.0.4.10) : (19061859)"
Sub-patch 18825509; "DATABASE PATCH FOR EXADATA (JUL2014 - 11.2.0.4.9) : (18825509)"
Sub-patch 18642122; "DATABASE PATCH FOR EXADATA (JUN2014 - 11.2.0.4.8) : (18642122)"
Sub-patch 18552960; "DATABASE PATCH FOR EXADATA (MAY2014 - 11.2.0.4.7) : (18552960)"
Sub-patch 18293775; "DATABASE PATCH FOR EXADATA (APR2014 - 11.2.0.4.6) : (18293775)"
Sub-patch 18136151; "DATABASE PATCH FOR EXADATA (MAR2014 - 11.2.0.4.5) : (18136151)"
Sub-patch 18006299; "DATABASE PATCH FOR EXADATA (FEB2014 - 11.2.0.4.4) : (18006299)"
Sub-patch 17943261; "DATABASE PATCH FOR EXADATA (JAN2014 - 11.2.0.4.3) : (17943261)"
Sub-patch 17741631; "DATABASE PATCH FOR EXADATA (DEC 2013 - 11.2.0.4.2) : (17741631)"
Sub-patch 17628006; "DATABASE PATCH FOR EXADATA (NOV 2013 - 11.2.0.4.1) : (17628006)"
Bugs fixed:
17288409, 16188701, 21051852, 16930924, 17205719, 17811429, 13640676
18607546, 20506699, 14705949, 17816865, 17922254, 17754782, 13364795
16934803, 17311728, 18418934, 16809786, 17284817, 17441661, 14275161
………