ksedmp: internal or fatal error
ORA-07445: 出现异常错误: 核心转储 [ldxsnf()+625] [SIGSEGV] [Address not mapped to object] [0x2B28910C94F0] [] []
Current SQL statement for this session:
SELECT * FROM aa
where
trunc(sysdate) between ...
#######################################
数据库版本：Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
参考MOS：
Bug 6641866 - Dump from operations on DATE values (文档 ID 6641866.8)
ORA-07445 [Ldxsnf] even with patch 6641866 applied (文档 ID 1159983.1)
Bug 6641866中的描述：
Description
A dump can occur (eg under ldxsnfcom <- ldxsnf <- ldxgpc <- evadrn)
文档1159983.1中的描述：
The bug can be identified based on the following facts:
1. ORA-7445 is raised in ldxsnfcom()
2. following functions at the top of the stack: ldxsnf ldxgpc evadrn
3. sql trace (10046 event) on the session reveals "alter session set nls_language". More specifically, the incorrect value being set is similar to
"alter session set NLS_LANGUAGE = 'US'" directly or via "DBMS_SESSION.SET_NLS('NLS_LANGUAGE','US')".
Bug 9746699 is fixed in 12.1 and patch set 11.2.0.2.
#########################################
结合ORA-07455时TRACE文件中的SQL语句，存在and trunc(sysdate)语句,应该就是这原因了。