ORA-07445: 出现异常错误: 核心转储...

--查看
select a.ksppinm name, b.ksppstvl value, a.ksppdesc description  from x$ksppi a, x$ksppcv b where a.indx = b.indx and a.ksppinm = '_optimizer_join_elimination_enabled';
输出为
NAME           VALUE          DESCRIPTION
---------------------------------------- -------------------- ----------------------------------------
_optimizer_join_elimination_enabled   FALSE          optimizer join elimination enabled
--修改参数
alter system set "_optimizer_join_elimination_enabled"=false scope=both;
复制