ORA-7445 [kkorminl] or similar can occur when running Automatic tuning tasks

郑全

Bug 17339455 - ORA-7445 [kkorminl] or similar can occur when running Automatic tuning tasks / DBMS_SQLTUNE Index Advisor (Doc ID 17339455.8)

Bug 17339455  ORA-7445 [kkorminl] or similar can occur when running Automatic tuning tasks / DBMS_SQLTUNE Index Advisor
This note gives a brief overview of bug 17339455.
The content was last updated on: 18-MAY-2018
Click here for details of each of the sections below.
Affects:
Product (Component)
Oracle Server (Rdbms)
Range of versions believed to be affected
(Not specified)
Versions confirmed as being affected
11.2.0.4
Platforms affected
Generic (all / most platforms affected)
Fixed:
The fix for 17339455 is first included in
12.2.0.1 (Base Release)
12.1.0.2 (Server Patch Set)
Interim patches may be available for earlier versions - click here to check.
Symptoms:
Related To:
Process May Dump (ORA-7445) / Abend / Abort
ORA-600 [qerixAddNotNullStopKeyPredicate:1]
Dump in or under kkorminl
Optimizer
PL/SQL (DBMS Packages)
DBMS_SQLTUNE
Description

ORA-7445 [kkorminl] or similar can occur when running DBMS_SQLTUNE
Index Advisor on queries with inlists. This is most likely to occur when running
an automatic tuning task that runs Index Advisor.

Workaround
If the issue occurs during automatic tuning then an option to avoid the dumps is to
disable the automatic tuning job.
eg:
  BEGIN
   dbms_auto_task_admin.disable(
    client_name => 'sql tuning advisor',
    operation => NULL,
    window_name => NULL);
  END;
  /