ORA-07445:出现异常：核心转储[00000001003EAE08] [SIGSEGV]
数据库版本：Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
操作系统：
Hostid: 8309db39
Release: 5.9
Kernel architecture: sun4u
Application architecture: sparc
Hardware provider: Sun_Microsystems
Domain:
Kernel version: SunOS 5.9 Generic 118558-28 May 2006
alert报错：
Wed Dec 31 09:59:37 2014
Errors in file /oracle/admin/eagle/udump/eagle2_ora_27204.trc:
ORA-07445:出现异常：核心转储 [] []
Wed Dec 31 09:59:37 2014
Trace dumping is performing id=
报错sql是两个视图视图关联，视图单独查询是没有问题，插入临时表然后用临时表关联也是没有问题的，求刘大有空看看 ksedmp: internal or fatal error
ORA-07445: 出现异常: 核心转储 [] []
Current SQL statement for this session:
select a.wdate,
a.supplierid,
a.suppliername,
a.productid,
a.productname,
a.color,
a.style,
a.costprice,
b.wcount 进货数,
a.wcount 出货数
from voaf_shipment_by_wl a
full join voaf_stock_by_wl b
on a.wdate = b.wdate
and a.supplierid = b.supplierid
and a.suppliername = b.suppliername
and a.productid = b.productid
and a.productname = b.productname
and a.color = b.color
and a.style = b.style
and a.costprice = b.costprice
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ?
000000000 ? 00000004A ?
FFFFFFFF7FFF1CE8 ?
102F2D5E8 ?
ssexhd()+676 CALL ksedmp() 000103311 ? 103311000 ?
1033117A8 ? 103316000 ?
000102800 ? 000000000 ?
sigacthandler()+44 PTR_CALL 0000000000000000 000103319 ?
FFFFFFFF7FFF8D80 ?
103319000 ? 103316960 ?
000000000 ? 1033198B8 ?
qkngbAllocate()+328 PTR_CALL 0000000000000000 00000000B ?
FFFFFFFF7FFF8D80 ?
FFFFFFFF7FFF8AA0 ?
846676630 ? 103314070 ?
000000002 ?
qkagby()+1640 CALL qkngbAllocate() FFFFFFFF7ACDEC08 ?
8466765E0 ? 7C8DF1DA0 ?
000000009 ? 000000001 ?
000000000 ?
qkaqkn()+2164 CALL qkagby() 8466765E0 ?
FFFFFFFF7ACC0888 ?
FFFFFFFF7FFF94E8 ?
000000009 ? 000000000 ?
000000001 ?
qkadrv()+448 CALL qkaqkn() 000000000 ?
FFFFFFFF7FFF9678 ?
FFFFFFFF7B049A68 ?
000000000 ? 000000001 ?
80AFE86F8 ?
qkadrv()+2288 CALL qkadrv() 000000000 ? 103311000 ?
80AFE86F8 ? 000000000 ?
FFFFFFFF7B049A68 ?
000000000 ?
qkadrv()+2600 CALL qkadrv() FFFFFFFF7B049740 ?
FFFFFFFF7B45EA80 ?
80AFE86F8 ? 000000000 ?
qkngbAllocate Allocates a GROUP_BY_QKNTYP node. The subtype GB_NOSORT_QKNGBTYP, GB_SORT_QKNGBTYP or GB_ROLLUP_QKNGBTYP is derived from the value of flags. 9206 这个版本也太老了，你这问题可能可以通过 调整optimizer 来workaround ，但实际更应当升级 谢谢刘大的分析，下次如果碰到就先调整optimizer试试看，因为是临时出报表的sql，目前采用定时插入临时表处理暂时没有报错提示，公司也已经有数据库升级计划，再次感谢！
页:
[1]