Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Scheduling of Update Statistics wrt DB Check

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

Not what you were looking for? View more on this topic or Ask a question