--备份隐含参数
sqlplus / as sysdba
spool /tmp/yincan.txt
col parameter for a35
col "session value" for a15
col "instance value" for a15
SELECT a.ksppinm "parameter",
b.ksppstvl "session value",
c.ksppstvl "instance value"
FROM x$ksppi a, x$ksppcv b, x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm in ('_b_tree_bitmap_plans','_no_or_expansion','_complex_view_merging','_optimizer_cost_based_transformation','_pred_move_around');
spool off;
--备份初始化参数
sqlplus / as sysdba
create pfile='/tmp/1015.ora' from spfile;
--修改数据库参数
alter system set "_b_tree_bitmap_plans"=FALSE scope=both sid='*';
alter system set "_complex_view_merging"=TRUE scope=both sid='*';
alter system set "_no_or_expansion"=TRUE scope=both sid='*';
alter system set "_optimizer_cost_based_transformation"=on scope=both sid='*';
alter system set "_pred_move_around"=FALSE scope=both sid='*';
alter system set optimizer_features_enable='11.2.0.4' scope=both sid='*';
如果alter system set optimizer_features_enable='11.2.0.4' scope=both sid='*';不行的话,则
alter system set optimizer_features_enable='10.2.0.4' scope=both sid='*';
如果是19c的数据库,则alter system set optimizer_features_enable='12.2.0.1' scope=both sid='*'; 如果还是报错则alter system set optimizer_features_enable='10.2.0.4';