ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [ktsplbfmb-dblfree], [0], [8472324]
查看数据库日志存在异常报错ORA-00600：
Wed May 06 17:00:14 2020
Errors in file /u01/app/oracle/diag/rdbms/prtestdborcl/prtestdborcl/trace/prtestdborcl_m000_17750.trc (incident=193665):
ORA-00600: internal error code, arguments: [ktsplbfmb-dblfree], [0], [8472324], [8472322], [2], [0], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/prtestdborcl/prtestdborcl/incident/incdir_193665/prtestdborcl_m000_17750_i193665.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/prtestdborcl/prtestdborcl/trace/prtestdborcl_m000_17750.trc (incident=193666):
ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [ktsplbfmb-dblfree], [0], [8472324], [8472322], [2], [0], [], [], [], [], [], []
], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/prtestdborcl/prtestdborcl/incident/incdir_193666/prtestdborcl_m000_17750_i193666.trc
Wed May 06 17:00:15 2020
Dumping diagnostic data in directory=[cdmp_20200506170015], requested by (instance=1, osid=17750 (M000)), summary=[incident=193665].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/prtestdborcl/prtestdborcl/trace/prtestdborcl_m000_17750.trc:
ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600: internal error code, arguments: [ktsplbfmb-dblfree], [0], [8472324], [8472322], [2], [0], [], [], [], [], [], []
], [], [], [], [], [], [], [], [], []
Wed May 06 17:00:16 2020
Sweep [inc][193666]: completed
Sweep [inc][193665]: completed
Sweep [inc2][193666]: completed
Sweep [inc2][193665]: completed
Dumping diagnostic data in directory=[cdmp_20200506170016], requested by (instance=1, osid=17750 (M000)), summary=[incident=193666].
根据错误提示，涉及到一些trace文件，查看以下trace文件信息：
/u01/app/oracle/diag/rdbms/prtestdborcl/prtestdborcl/trace/prtestdborcl_m000_17750.trc
/u01/app/oracle/diag/rdbms/prtestdborcl/prtestdborcl/incident/incdir_193666/prtestdborcl_m000_17750_i193666.trc
从trace文件中查看涉及到系统表wrh$_sql_plan的插入操作，该表涉及AWR报告中的视图：
手工执行一些快照还原一情况，同时查看日志出现上面一样的报错：
SQL> exec dbms_workload_repository.create_snapshot;
BEGIN dbms_workload_repository.create_snapshot; END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kewrose_1], [600], [ORA-00600:
internal error code, arguments: [ktsplbfmb-dblfree], [0], [8472324], [8472322],
[2], [0], [], [], [], [], [], []
], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 99
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 122
ORA-06512: at line 1
SQL>
使用ORA-600/ORA-7445/ORA-700 Error Look-up Tool (Doc ID 153788.1)查找具体的报错信息
查看这对应的详细信息
查看对应的详细信息及堆栈信息：
从这里看看命中了Bug 18229901 - ORA-600 [qolhintpivaddsid:1], [25145], [25145 (Doc ID 18229901.8)
建议修改隐含参数：
alter system set "_b_tree_bitmap_plans"=false scope=both;
alter system set "_index_join_enabled"=false scope=both;
修改参数后，仍然报错，查看单个的补丁集：
根据自己的数据库版本查找对应的补丁集
根据readme进行升级补丁集：
进行升级补丁后，执行AWR快照没有问题：
SQL> exec dbms_workload_repository.create_snapshot;
PL/SQL procedure successfully completed.
