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

标题: ORA-7445 [kkorminl] or similar can occur when running Automatic tuning tasks [打印本页]

作者: 郑全 时间: 2019-12-10 22:58
标题: 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;
  /

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