ORA-00600: [qksdsInitSample:2]
DB:Oracle 11.2.0.1.0
OS:Windows Server 2012
问题现象：
alert_eascjc.log告警日志每天晚上22点多都会有如下报错产生：
ORA-00600: [qksdsInitSample:2], [T_CSL_CSLREPORT], [], [], [], [], [], [], [], [], [], []
问题分析：
查看eascjc_j003_592.trc日志：
查看eascjc_j003_592_i80673.trc日志可以看到：
(1)当前执行的SQL带有/* SQL Analyze(7,1)*/
(2)package body带有SYS.DBMS_SQLTUNE_INTERNAL
(3)每天错误发生在晚上22点零几分钟
初步怀疑和数据自带的sql tuning advisor有关
查看My Oracle Support此问题
和 Bug 8797501 比较吻合，已知受影响的版本有 11.2.0.1 、 11.1.0.7 、 10.2.0.4 ，已在 11.2.0.2 (Server Patch Set) 和 12.1.0.1 (Base Release) 版本修复。
Bug 8797501 - OERI [qksdsInitSample:2] from SQL Tuning (文档 ID 8797501.8)
Description：
ORA-600 [qksdsInitSample:2] can occur during SQL tuning.
解决方案：
禁用sql tuning advisor
禁用后，第二天查看，已经不在出现ORA-00600: [qksdsInitSample:2]错误了；
SQL> select * from dba_autotask_client;
SQL>
BEGIN
dbms_auto_task_admin.disable(client_name => 'sql tuning advisor',
operation => NULL,
window_name => NULL);
END;
SQL> select * from dba_autotask_client;
My Oracle Support相关内容如下：
Bug 8797501 OERI [qksdsInitSample:2] from SQL Tuning
This note gives a brief overview of bug 8797501.
The content was last updated on: 19-FEB-2019
Click
here
for details of each of the sections below.
Affects:
|
Product ( Component ) |
Oracle Server (Rdbms) |
|
Range of versions believed to be affected |
Versions BELOW 12.1 |
|
Versions confirmed as being affected |
|
|
Platforms affected |
Generic (all / most platforms affected) |
Fixed:
|
The fix for 8797501 is first included in |
Interim patches may be available for earlier versions - click
here
to check.
Symptoms: |
Related To: |
|
Description
ORA-600 [qksdsInitSample:2] can occur during SQL tuning.