--------------ORA-03113: end-of-file on--------------
SQL> show parameter background_dump;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /home/u01/oracle/diag/rdbms/or
cl/orcl/trace
[oracle@VM_179_95_centos trace]$ tail -f alert_orcl.log
Fri Dec 07 09:52:07 2018
Sweep [inc][68390]: completed
Fri Dec 07 09:52:18 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x71] [PC:0x1CB9CA9, kkqstcrf()+1355] [flags: 0x0, count: 1]
Errors in file /home/u01/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_28798.trc (incident=68319):
ORA-07445: exception encountered: core dump [kkqstcrf()+1355] [SIGSEGV] [ADDR:0x71] [PC:0x1CB9CA9] [Address not mapped to object] []
Fri Dec 07 09:53:07 2018
Sweep [inc][68319]: completed
ORA-07445: 出现异常错误: 核心转储 [kkqstcrf()+1355]
解决方案：
trace里当前SQL引用多个left outer join，在11.2.0.1.0版本，外关联存在多个BUG；
查看MOS和BUG 9050716比较匹配，禁用_optimizer_join_elimination_enabled参数问题解决；
SQL> alter system set "_optimizer_join_elimination_enabled"=false scope=both;
SQL> alter system set "_optimizer_join_elimination_enabled"=false scope=both;
---查看_optimizer_join_elimination_enabled参数值
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';