Hello,
I have a question that is rattling my brain but I cannot find anything in SAP help or SAP notes.
Recently, while monitoring our customer SAP systems running on Oracle db, we found that we were getting repititive MISSING_STATISTICS alerts daily. We checked and found that both 'Update Statistics' and 'DBCHECK' were scheduled to run daily at the following times:
The current schedule for DEV system is
01:00 UpdateStats
06:00 CheckDB
The current schedule for QAS system is
03:00 UpdateStats
04:00 CheckDB
Someone suggested to us that the solution is to change this schedule in a manner that CheckDB runs 1 hr before UpdateStats.
But this doesn't make sense to me because if CheckDB runs before UpdateStats, then the CheckDB will still throw the same missing_statistics alerts the next day instead of same day. As a result, we will still be getting these alerts, even if they come one day late.
My question is:
1. Is that person correct in suggesting this change of schedule?
2. Is there any way, we can avoid getting these repititive alerts and find a permanent fix for this problem?
Any suggestions and/or references to SAP Notes/help topics are most welcome.
Regards,
Shitij