昨晚02：52分，一个单实例11.2.0.4的库报出600错误，下面是alert日志截取，我将自动维护任务窗口调整到02:00至：06:00了，附件为trace文件，请刘大和各位同仁协助分析一下，看是否是oracle的bug。
Tue Apr 26 02:00:00 2016
Setting Resource Manager plan SCHEDULER[0x32DA]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Tue Apr 26 02:00:00 2016
Starting background process VKRM
Tue Apr 26 02:00:00 2016
VKRM started with pid=154, OS id=8868
Tue Apr 26 02:00:01 2016
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue Apr 26 02:52:35 2016
Errors in file /u01/app/oracle/diag/rdbms/hfp/HFP/trace/HFP_j003_8888.trc (incident=57297):
ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/hfp/HFP/incident/incdir_57297/HFP_j003_8888_i57297.trc
Tue Apr 26 02:52:43 2016
Dumping diagnostic data in directory=[cdmp_20160426025243], requested by (instance=1, osid=8888 (J003)), summary=[incident=57297].
Tue Apr 26 02:52:43 2016
Sweep [inc][57297]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Apr 26 02:52:46 2016
Sweep [inc2][57297]: completed
Tue Apr 26 03:00:03 2016
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Tue Apr 26 03:38:56 2016
ALTER SYSTEM ARCHIVE LOG
Tue Apr 26 03:38:56 2016
Thread 1 advanced to log sequence 1500 (LGWR switch)
Current log
# 10 seq#
1500 mem# 0: /u02/app/oracle/oradata/HFP/redo10.log
Archived Log entry 1496 added for thread 1 sequence 1499 ID 0x34671377 dest 1:
ALTER SYSTEM ARCHIVE LOG
Thread 1 advanced to log sequence 1501 (LGWR switch)
Current log# 1 seq
# 1501 mem#
0: /u02/app/oracle/oradata/HFP/redo01.log
Archived Log entry 1497 added for thread 1 sequence 1500 ID 0x34671377 dest 1:

ORA-600 [qkaffsindex3] or ORA-600 [qkaffsindex5] Raised For SQL Tuning Advisor (文档 ID 2022280.1)
In this Document
Symptoms
Cause
Solution
References
Applies to:Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.1 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Symptoms
For the SQL Tuning Advisor, next error is raised in the alert log for a SQL Analyze job:
ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []
- OR -
ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], []
The trace file shows characteristics like below (for an ORA-600 [qkaffsindex3]):
*** 2015-06-18 22:38:41.671
*** SESSION ID:(719.63605) 2015-06-18 22:38:41.671
*** CLIENT ID:() 2015-06-18 22:38:41.671
*** SERVICE NAME:(SYS$USERS) 2015-06-18 22:38:41.671
*** MODULE NAME:(DBMS_SCHEDULER) 2015-06-18 22:38:41.671
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_2818) 2015-06-18 22:38:41.671
ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], [], [], [], [], []
----- Current SQL Statement for this session (sql_id=cqqjd10qcu0kf) -----
/* SQL Analyze(323,1) */ < failing sql statement >
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x9ad2bb770 11829 package body SYS.DBMS_SQLTUNE_INTERNAL
0x9bb75d308 7 SYS.WRI$_ADV_SQLTUNE
0x9ae730318 601 package body SYS.PRVT_ADVISOR
0x9ae730318 2678 package body SYS.PRVT_ADVISOR
0x9a7d41fb0 241 package body SYS.DBMS_ADVISOR
0x9bf2f6a10 821 package body SYS.DBMS_SQLTUNE
0x99fc01fd8 4 anonymous block
----- Call Stack Trace -----
... qkaffsindex qkatab qkajoi qkaqkn qkadrv qkadrv opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 kpooprx kpoal8 opiodr ...
Note that the trace file shows:
The failing current SQL a "/* SQL Analyze(...) */" comment
The PLSQL call stack shows DBMS_SQLTUNE
Cause
The ORA-600 [QKAFFSINDEX5] is discussed in
Bug 18872081 - ORA-600 [QKAFFSINDEX5]
closed as a duplicate of the underlying cause as identified in unpublished
Bug 18189036 - ORA-600 [QKAFFSINDEX3], [], [], [], [], []
The base bug is a.o. fixed in:
12.2 (Future Release)
12.1.0.2 (Server Patch Set)
11.2.0.4.5 (Jan 2015) Database Patch Set Update (DB PSU) as documented in <19769489.8>
Please refer to:
Note 18189036.8 - Bug 18189036 - ORA-600 [qkaffsindex3] from SQL Tuning task / advisor
Solution
To solve the issue, use any of below alternatives:
Apply patch set 12.1.0.2
- OR -
Apply PSU 11.2.0.4.5
- OR -
Apply interim patch 18189036, if available for your platform and Oracle version.
To check for conflicting patches, please use the MOS Patch Planner Tool
Please refer to
Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?
If no patch exists for your version, please contact Oracle Support for a backport request.
There is no actual workaround other than to disable automatic SQL tuning if the error keeps repeating during automatic tuning.
ReferencesNOTE:18189036.8 - Bug 18189036 - ORA-600 [qkaffsindex3] from SQL Tuning task / advisor
NOTE:234628.1 - ORA-600 [qkaffsindex3]

Bug 18189036 - ORA-600 [qkaffsindex3] from SQL Tuning task / advisor (文档 ID 18189036.8)
Bug 18189036 ORA-600 [qkaffsindex3] from SQL Tuning task / advisor This note gives a brief overview of bug 18189036.
The content was last updated on: 17-DEC-2015
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.2
Versions confirmed as being affected 12.1.0.1 (Base Release)11.2.0.411.2.0.3
Platforms affected Generic (all / most platforms affected)
Fixed:
The fix for 18189036 is first included in 12.2 (Future Release)12.1.0.2 (Server Patch Set)11.2.0.4.5 (Jan 2015) Database Patch Set Update (DB PSU)11.2.0.4 Bundle Patch 14 for Exadata Database (Dec 2014)12.1.0.1 Patch 12 on Windows Platforms11.2.0.4 Patch 12 on Windows Platforms11.2.0.3 Patch 31 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 [qkaffsindex3]Stack is likely to include qksanAnalyzeSql PL/SQL (DBMS Packages)DBMS_SQLTUNE
DescriptionORA-600 [qkaffsindex3] can occur when executing an automatic SQL Tuning Advisor task. Rediscovery Notes This bug may be suspected if the following are true: - ORA-600 [qkaffsindex3] occurs - The SQL being parsed shows a "/* SQL Analyze(...) */" comment - The PLSQL call stack shows DBMS_SQLTUNE Workaround One option to avoid the errors 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; /
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.
ReferencesBug:18189036 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article