Core dump file generation and ORA-07445 [kkorminl()] error (Doc ID 2198790.1)

Last updated on AUGUST 04, 2018

Applies to:

Symptoms

1. ORA-07445 error reported in the alert log:
ORA-07445: exception encountered: core dump [kkorminl()]

2. Incident trace reports the error plus details indicating execution of SQL Tuning Advisor:
ORA-07445: exception encountered: core dump [kkorminl()] [SIGSEGV] [ADDR:0xFFFFFFFF7DFFE000] [PC:0x102EA4860] [Stack Overflow] []

...

----- Current SQL Statement for this session (sql_id=9v57mb092px43) -----

/* SQL Analyze(320,1) */
SELECT .......

----- PL/SQL Call Stack -----
object line object
handle number name
4fb303040 0 package body SYS.DBMS_SQLTUNE_INTERNAL
4fb225fa0 0 SYS.WRI$_ADV_SQLTUNE
4fb5e12c8 0 package body SYS.PRVT_ADVISOR
4fb5e12c8 0 package body SYS.PRVT_ADVISOR
4fb30c598 0 package body SYS.DBMS_ADVISOR
4fb80aba0 0 package body SYS.DBMS_SQLTUNE
4fb267828 4 anonymous block

3. Call Stack similar to:

kkorminl <- kkorminl <- kkorminl
<- kkorminl <- kkorminl <- kkoConvertFilterInLists <- kkoipt
<- kkoqbc <- apakkoqb <- apaqbdDescendents <- apadrv

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.