ORA-07445 [kkoatSampPred()] (Doc ID 1922883.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The following error is encountered in the alert log and trace file:

ORA-07445: exception encountered: core dump [kkoatSampPred()+26] [SIGSEGV] [ADDR:0x24] [PC:0x5A7B3DE] [Address not mapped to object] []

 
The trace file shows that the process is executing SQL Tuning Advisor because the SQL starts with /* SQL Analyze */

----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x24] [PC:0x5A7B3DE, kkoatSampPred()+26] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000001 %rbx: 0x0000000000000002 %rcx: 0x0000000000000000
%rdx: 0x000000000000002a %rdi: 0x00007fad2d2df570 %rsi: 0x0000000000000001
%rsp: 0x00007fffd1192870 %rbp: 0x00007fffd1192890 %r8: 0x0000000000000006
%r9: 0x0000000000000004 %r10: 0x0000000000000000 %r11: 0x0000000610b340a0
%r12: 0x00007fad2d2d9060 %r13: 0x0000000000000004 %r14: 0x00007fad2d2d9050
%r15: 0x0000000000000000 %rip: 0x0000000005a7b3de %efl: 0x0000000000010246
kkoatSampPred()+8 (0x5a7b3cc) mov 0x30(%rdi),%edx
kkoatSampPred()+11 (0x5a7b3cf) test $0x2000,%edx
kkoatSampPred()+17 (0x5a7b3d5) jnz 0x5a7b49b
kkoatSampPred()+23 (0x5a7b3db) mov (%rdi),%rcx
> kkoatSampPred()+26 (0x5a7b3de) mov 0x24(%rcx),%eax

*** 2014-08-06 22:03:35.514
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=d65p9nd20jmur) -----
/* SQL Analyze(16,1) */ /* 7017b3dc */WITH
SAWITH0 AS (select..

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x626ff2988 11816 package body SYS.DBMS_SQLTUNE_INTERNAL
0x6192a6ad8 7 SYS.WRI$_ADV_SQLTUNE
0x6273d44b8 587 package body SYS.PRVT_ADVISOR
0x6273d44b8 2655 package body SYS.PRVT_ADVISOR
0x622fbdf38 241 package body SYS.DBMS_ADVISOR
0x623062e28 821 package body SYS.DBMS_SQLTUNE
0x5ee31bdb8 4 anonymous block

 
The 'Call Stack' section of the trace file includes functions similar to:

.. kkoatSampPred  kkoatGetPreds  kkoatVerifyEst  kkeAdjJoinPrefCard  kkejcd  kkojnp  kkocnp  kkooqb  kkoqbc  apakkoqb  apaqbdDescendents  apaqbdList ..

  

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms