Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x118] [PC:0x1CE6BEB, kkqfppDrv1()+101] [flags: 0x0, count: 1]

Errors in file *_ora_31425.trc (incident=37965):

ORA-07445: 出现异常错误: 核心转储 [kkqfppDrv1()+101] [SIGSEGV] [ADDR:0x118] [PC:0x1CE6BEB] [Address not mapped to object] []

Incident details in: *_ora_31425_i37965.trc

查看日志发现是with与distinct同时使用，类似于如下

with a as(

select * from testa

),b as (

select ip,count(distinct cust_id) cust_num

from a

group by ip

)

select * from b;

在王、赵总的帮助下，确认为oracle的bug，解决方法有两种：

打补丁：If you are installing using Oracle Database 11g Release 2 (11.2.0.1.0), then ensure that you apply the patch for bug# 9002336 and 9067282

修改sql：with与distinct不能同时使用。

此次为修改sql解决

Description

Dump in kkqfppDrv1 of a query containing WITH clause and distinct aggregates.

It is possible to dump or spin in other functions too.

ITPub博客

ORA-07445:出现异常错误:核心转储[kkqfppDrv1()+101]Address not mapped to object