on 08-03-2016 8:38 AM
Hello,
We are using oracle 11g in our SAP ERP system. We had a problem with one business job for long sequential read of one business table. When checked for that table in DB20, last statistics was executed four months back. So we executed the statistics for that table alone in DB20 and scheduled the job again. The job is completed immediately.
Now we want to execute the statistics for selected business tables every week scheduling as a periodic job. Please let me know how we can achieve this.
Thanks and Regards,
Anand
Hi Anand,
It is likely that the default of 50% of changes is too high for some tables in your system. If that is the case, you have the option of setting the stats_change_threshold parameter in your init<SID>.sap to a lower value to avoid this from happening again.
Best regards,
Thiago
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anand,
Have you scheduled db13 statistics update job?
If you did, we need to focus on why the job exclude those tables. Or we can customize the statistics job as mentioned in SAP note:
106047 - DB21: Customizing the DBSTATC
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The table DBSTATC is a control table used by BR*Tools / DB13 for the statistics update.
The DB13 jobs checks this table before the statistics collection which is then triggered using BR*Tools. As long as you maintain the entries correctly there will be no issues. If you do not want to include these tables in the daily statistics collection then create a cron script / batch job at the OS level to have it triggered whenever you want the statistics collection to be done. Also there is no need to schedule DB13 statistics collection everyday. Once in a week should be sufficient.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.