Hello all,
Had this ORA-600?
ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []
Investigating on issue:
– Alert Log:
Wed Mar 29 22:01:04 2017 Errors in file /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc (incident=56945): ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56945/PRODDB_j001_44375_i56945.trc Errors in file /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc (incident=56946): ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], [] Incident details in: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56946/PRODDB_j001_44375_i56946.trc Wed Mar 29 22:01:07 2017 Trace dumping is performing id=[cdmp_20170329220107] Wed Mar 29 22:01:08 2017 Sweep [inc][56945]: completed Sweep [inc2][56945]: completed Wed Mar 29 22:01:08 2017 Sweep [inc][56946]: completed Sweep [inc2][56946]: completed End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
You already saw that I left the auto task ending there, right? You’ll see. 🙂
– Trace: /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc
Trace file /opt/oracle/app/diag/rdbms/proddb/PRODDB/trace/PRODDB_j001_44375.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME = /opt/oracle/app/product/11.2.0/ System name: Linux Node name: DBSERVER.domain.com Release: 2.6.32-431.el6.x86_64 Version: #1 SMP Sun Nov 10 22:19:54 EST 2013 Machine: x86_64 Instance name: PRODDB Redo thread mounted by this instance: 1 Oracle process number: 118 Unix process pid: 44375, image: oracle@DBSERVER.domain.com (J001) *** 2017-03-29 22:00:05.312 *** SESSION ID:(1167.61110) 2017-03-29 22:00:05.312 *** CLIENT ID:() 2017-03-29 22:00:05.312 *** SERVICE NAME:(SYS$USERS) 2017-03-29 22:00:05.312 *** MODULE NAME:(DBMS_SCHEDULER) 2017-03-29 22:00:05.312 *** ACTION NAME:(ORA$AT_SQ_SQL_SW_3987) 2017-03-29 22:00:05.312 status=(pst=SUCCESS) ************************************************************** Execution Statistics Exec count: 1 CR gets: 16408 CU gets: 0 Disk Reads: 0 Disk Writes: 0 IO Read Requests: 0 IO Write Requests: 0 Bytes Read: 0 Bytes Written: 0 [...] Execution Statistics Exec count: 1 CR gets: 504 CU gets: 0 Disk Reads: 0 Disk Writes: 0 IO Read Requests: 0 IO Write Requests: 0 Bytes Read: 0 Bytes Written: 0 Bytes Exchanged with Storage: 0 Bytes Exchanged with Disk: 0 Bytes Simulated Read: 0 Bytes Simulated Returned: 0 Elapsed Time: 757 (us) CPU Time: 799 (us) User I/O Time: 0 (us) status=(pst=ERROR) *** 2017-03-29 22:01:04.987 Incident 56945 created, dump file: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56945/PRODDB_j001_44375_i56945.trc ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], [] Incident 56946 created, dump file: /opt/oracle/app/diag/rdbms/proddb/PRODDB/incident/incdir_56946/PRODDB_j001_44375_i56946.trc ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], []
OK, don’t worry!
This is a know issue described as per MOS ORA-600:internal Error Code, Arguments: [ktsapsblk-1], [], [], [], [], [], [], [], [], [], [], [] (Doc ID 1490663.1).
It applies to 11.2.0.1 to 11.2.0.3, being fixed on 11.2.0.4. There is also patch 13814203 for 11.2.0.3, but need a port request if you are in different PSU.
The workaround?
Easy, disable SQL Running Advisor Task:
SQL> SELECT client_name, status FROM dba_autotask_operation; CLIENT_NAME STATUS ---------------------------------------------------------------- -------- auto optimizer stats collection ENABLED auto space advisor ENABLED sql tuning advisor ENABLED SQL> exec dbms_auto_task_admin.disable('sql tuning advisor',NULL,NULL) PL/SQL procedure successfully completed. SQL> SELECT client_name, status FROM dba_autotask_operation; CLIENT_NAME STATUS ---------------------------------------------------------------- -------- auto optimizer stats collection ENABLED auto space advisor ENABLED sql tuning advisor DISABLED
See you next week!