ora-00600:[qerpxInitialize0]

年关将至数据库自动维护JOB(SYS_AUTO_SQL_TUNING_TASK)因ORA-00600数据库内部错误上眼药啊

1、数据库日志：

Fri Jan 28 22:00:00 2022
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Fri Jan 28 22:00:23 2022
Errors in file /u01/oracle/diag/rdbms/ORC/ORC1/trace/ORC1_j001_59914.trc (incident=85323):
ORA-00600: internal error code, arguments: [qerpxInitialize0], [0], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/oracle/diag/rdbms/ORC/ORC1/incident/incdir_85323/ORC1_j001_59914_i85323.trc
Fri Jan 28 22:00:36 2022
Dumping diagnostic data in directory=[cdmp_20220128220036], requested by (instance=1, osid=59914 (J001)), summary=[incident=85323].
Fri Jan 28 22:00:36 2022
Sweep [inc][85323]: completed
Fri Jan 28 22:00:36 2022
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Jan 28 22:00:38 2022
Sweep [inc2][85323]: completed
Fri Jan 28 22:02:19 2022
End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"

2、报错原因与SYS_AUTO_SQL_TUNING_TASK（系统自动优化建议）有关

– 查看系统自动优化建议（报告前一天的）
在做 SQL ID : 20tx30wjv8hm1 : a3prqzqkmjj3q 两个SQL时报的错

select dbms_sqltune.report_tuning_task('SYS_AUTO_SQL_TUNING_TASK')  from  dual;

-------------------------------------------------------------------------------
Object ID  : 286416
Schema Name: **
SQL ID     : 20tx30wjv8hm1
SQL Text   : ***********************************************

-------------------------------------------------------------------------------
ERRORS SECTION
-------------------------------------------------------------------------------
- ORA-00600: internal error code, arguments: [qerpxInitialize0], [0], [], [],
  [], [], [], [], [], [], [], []

-------------------------------------------------------------------------------
Object ID  : 286528
Schema Name: **
SQL ID     : a3prqzqkmjj3q
SQL Text   : ***********************************************

-------------------------------------------------------------------------------
ERRORS SECTION
-------------------------------------------------------------------------------
- ORA-00600: internal error code, arguments: [qerpxInitialize0], [0], [], [],
  [], [], [], [], [], [], [], []

-------------------------------------------------------------------------------

3、官网解释

4、临时处理

– 禁用任务：

BEGIN
dbms_auto_task_admin.disable(client_name => 'sql tuning advisor',operation   => NULL,window_name => NULL);
END;

– 查看状态

select CLIENT_NAME, STATUS   from DBA_AUTOTASK_CLIENT;

– 后期想启用：

BEGIN
dbms_auto_task_admin.enable(client_name => 'sql tuning advisor',operation   => NULL,window_name => NULL);
END;