Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve Oracle ORA-00600 error". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian slowly and deeply to study and learn "how to solve Oracle ORA-00600 error" together!

Oracle 12.2.0.1 recently had an ORA--0600 error with the following details:

ORA-00600: Internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [],[],[], [],[],[], [],[],[], []ORA-06512: in "SYS.DBMS_STATS", line 1976ORA-06512: in "SYS.DBMS_STATS", line 46935ORA-06512: in "SYS.DBMS_STATS", line 47168ORA-00600: Internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [],[], [],[],[],[],[],[], []ORA-06512: in "SYS.DBMS_STATS", line 1976ORA-06512: in "SYS.DBMS_STATS", line 46935ORA-06512: in "SYS. DBMS_STATS", line 47168

According to Oracle's official SQL statement, the execution result is as follows:

The reason for the visit problem is that the row data of sys.exp_obj$.exp_cnt does not match sys.exp_stat$

solutions

1. Backing up a database involves modifying the data dictionary

2. fix the problem

SQL>update sys.exp_obj$ a set exp_cnt=(select count(*) from sys.exp_stat$ b wherea.objn=b.objn and a.snapshot_id=b.snapshot_id ) where a.objn=124789;SQL>commit;

3. After modification, execute the following SQL to confirm whether there are any records. If there are no records, it means that the modification has been successful and submitted.

SQL>With b as (select count(*) cnt,objn,snapshot_id from sys.exp_stat$ es group by objn,snapshot_id)select * from sys.exp_obj$ a, b where a.objn=b.objn and a.snapshot_id=b.snapshot_idand a.EXP_CNTb.CNT;

After the fix, the problem did not appear through a day of observation.

Thank you for reading, the above is "how to solve Oracle ORA-00600 error" content, after the study of this article, I believe that we have a deeper understanding of how to solve Oracle ORA-00600 error, the specific use of the situation also needs to be verified. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.