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;
