ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [], [], [], [], [], [], [], [], [], [], []

 Reason of the error:

This is due to sys.exp_obj$. EXP_CNT mismatch rows of sys.exp_stat$

 

Try workaround of MOS  Note 28681153.8  at both CDB and PDB. 

Solution

 Ensure that you have taken a backup of your system before applying the recommended solution.

 

Below SQL is used to check issue data of some objects. if there are some rows return, that means data issue

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_id
and a.EXP_CNT<>b.CNT;

 Find the details of the object

select  * from dba_objects where object_id='74329'

 

 

update sys.exp_obj$ a set exp_cnt=(select count(*) from sys.exp_stat$ b where
a.objn=b.objn and a.snapshot_id=b.snapshot_id ) where a.objn='74329';

 

 

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_id
and a.EXP_CNT<>b.CNT;