重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-07445 CORE Dump [qkacco()+91] [SIGSEGV] [ADDR:0x0] in 19c [打印本页]

作者: 郑全 时间: 2021-9-7 16:05
标题: ORA-07445 CORE Dump [qkacco()+91] [SIGSEGV] [ADDR:0x0] in 19c
ORA-07445 CORE Dump [qkacco()+91] [SIGSEGV] [ADDR:0x0] in 19c (文档 ID 2665233.1) 转到底部转到底部

In this Document
Symptoms
Cause
Solution
References

APPLIES TO:
Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and later
Information in this document applies to any platform.
SYMPTOMS
Select Failing with
ORA-07445: CORE Dump [qkacco()+91] [SIGSEGV] [ADDR:0x0] [PC:0x28498BB] [Address not mapped to object] []

Stack Trace:

qkacco <- qkajoi <- qkaqkn <- qkadrv <- opitca <- kksFullTypeCheck <- rpiswu2
<- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main

CAUSE
Issue is related to Bug 30621255 - QUERY FAILS WITH ORA-07445: [QKACCO()+91] as of 30th April 2020 the Bug was still been Worked upon by Development team

Version Affected 19c

SOLUTION
Error is reproducible even when run from sqlplus

Set first at session level and see if the workaround assist

alter session set "_optimizer_nlj_hj_adaptive_join"=FALSE;

<Run the problematic statement>

If it works set it at system level .

Its Normally used for adaptive joins that switch from nested loops to hash joins

So Impact may very you would need to compare the awr report after setting this parameter

作者: 郑全 时间: 2021-9-7 16:06
该问题在19.8 上也存在。

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)