ORA-00600 [qosdExpStatRead: expcnt mismatch]

Recently started seeing this error on few of the Exadata environments. ORA–00600: internal error code, arguments:[qosdExpStatRead: expcnt mismatch] Cause  This is due to sys.exp_obj$. EXP_CNT mismatch rows of sys.exp_stat$ Following 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$ […]

Read More