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:

Fixed:

Interim patches may be available for earlier versions - click  here  to check.

Description

ORA-600 [qksdsInitSample:2] can occur during SQL tuning.