ORA-00600: [qksdsInitSample:2]

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	11.2.0.1 11.1.0.7 10.2.0.4
Platforms affected	Generic (all / most platforms affected)

Fixed:

The fix for 8797501 is first included   in

12.1.0.1        (Base Release) 11.2.0.2        (Server Patch Set) 11.1.0.7        Patch 28 on Windows Platforms

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

Symptoms:	Related To:
Internal        Error May Occur (ORA-600) ORA-600        [qksdsInitSample:2]	PL/SQL        (DBMS Packages) DBMS_SQLTUNE

Description

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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29785807/viewspace-2649527/，如需轉載，請註明出處，否則將追究法律責任。