多表关联执行报错 ORA-07445:「kkqstcrf()+1355」

最新推荐文章于 2022-09-25 15:17:53 发布

cqszpx

最新推荐文章于 2022-09-25 15:17:53 发布

阅读量123

点赞数

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/cqszpx/article/details/126710197

版权

在执行SQL时遇到ORA-07445异常，'kkqstcrf()+1355'。该问题与Oracle 11.2.0.1版本的一个bug有关，涉及到ANSI JOINs和Join Elimination。解决方案包括设置 Optimizer参数或使用特定查询提示。

摘要由CSDN通过智能技术生成

晚上一SQL执行报错，具体报错：
Sun Apr 24 22:00:12 2022
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x71] [PC:0x1CBAD19, kkqstcrf()+1355] [flags: 0x0, count: 1]
Errors in file
/u01/app/oracle/diag/rdbms/jhemrdb/jhemr/trace/jhemr_j000_18569.trc (incident=38945):
查MOS上发现是11.2.0.1 的一个 bug, 具体如下：
Bug 9050716 Dumps on kkqstcrf with ANSI joins and Join Elimination
This note gives a brief overview of bug 9050716.
The content was last updated on: 08-MAR-2022
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions >= 10.2.0.1 but BELOW 12.1
Versions confirmed as being affected
11.2.0.1
11.1.0.7
Platforms affected Generic (all / most platforms affected)
Fixed:
The fix for 9050716 is first included in
12.1.0.1 (Base Release)
11.2.0.2 (Ser