ora 03113和ora 07445问题解决

 

今天在查询一个视图时，报错ora-03113

检查alert_sid.log发现有不少ora-07745错误信息，

Mon Dec 26 23:35:24 2011

Errors in file /home/oracle/admin/orcl/udump/orcl_ora_30361.trc:

ORA-07445: exception encountered: core dump [kkogbro()+192] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Mon Dec 26 23:47:22 2011

Errors in file /home/oracle/admin/orcl/udump/orcl_ora_30628.trc:

ORA-07445: exception encountered: core dump [kkogbro()+192] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

检查/home/oracle/admin/orcl/udump/orcl_ora_30628.trc:

*** 2011-12-26 23:47:22.382 ***

ACTION NAME:(Main session) 2011-12-26 23:47:22.382

*** MODULE NAME:(PL/SQL Developer) 2011-12-26 23:47:22.382

*** SERVICE NAME:(orcl) 2011-12-26 23:47:22.382

*** SESSION ID:(458.5255) 2011-12-26 23:47:22.382

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x1fff294, kkogbro()+192]

*** 2011-12-26 23:47:22.393

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [kkogbro()+192] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Current SQL statement for this session:

select * from DWJD_ADMIN.VIEW_XFHJXX

 

该视图语句如下：

该语句中使用多个left outer join，

在网上查找资料，然后增加swap、sga等都无法解决

后来参考http://www.itpub.net/thread-906727-1-1.html

对视图的语句进行分析，发现xfhj_yjxx表中的一个约束失效，删除重建后问题解决

转载于:https://www.cnblogs.com/cangos/archive/2011/12/28/2304173.html