My Oracle Support Banner

ORA-7445 [kokscold()+849] from Job Queue Process Running SQL Analyze (Doc ID 1115493.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 14-May-2013***

Symptoms

A job queue process fails with an error like:

ORA-07445: exception encountered: core dump [kokscold()+849] [SIGSEGV][ADDR:0x50] [PC:0x115E15F] [Address not mapped to object] []


The trace file shows the current SQL statement as something like:

/* SQL Analyze(397,1) */ MERGE INTO MGMT_ARU_PATCH_RECOMMENDATIONS p USING ...


With a PL/SQL stack like:

----- PL/SQL Call Stack -----
object line object
handle number name
0xc8dfd590 11774 package body SYS.DBMS_SQLTUNE_INTERNAL
0xdd8a6408 7 SYS.WRI$_ADV_SQLTUNE
0xdd6b9790 545 package body SYS.PRVT_ADVISOR
0xdd6b9790 2613 package body SYS.PRVT_ADVISOR
0xc8f9d120 241 package body SYS.DBMS_ADVISOR
0xc8e22780 772 package body SYS.DBMS_SQLTUNE
0xc88a6ae0 4 anonymous block


The disassemble shows:

> (0x115e15f) mov 0x50(%r11),%rdx
(0x115e163) movzbl 0x1(%r13),%ecx
(0x115e168) movzbl 0x1(%r15),%r9d
(0x115e16d) mov 0x8(%rdx),%edx
(0x115e170) lea 0x10(%r13),%r8


and the call stack is:

----- Call Stack Trace -----
... kokscold insolic insSetColumnInfo inspre0 upspre0 qkadml qkastmt qkadrv opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc opiexe ...

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.