Database statistics refresh jobs should be scheduled to run twice daily on all the SAP systems. But occasionally a manual refresh needs to be done due to table reorganization, index rebuild, etc.
- Log on to the appropriate SAP instance any client.
- Go to transaction DB13.
- On the DBA Planning Calender for Oracle Database <SID>: Maintain screen, double-click on a blank line on any day in the future.
- On the Schedule Action for <Day>. DD.MM.YYYY popup, use the radio button to turn "on" the task you want to do. For each action, you need to fill in the Start Time in military time format, the Period (Weeks) which is how many weeks between running of this job – blank for one time only, 1 for weekly, 2 for bi-weekly, etc. and Calender if you want to use any calendar except the SAP supplied standard Factory calendar.
These are the details for each action:
- Whole database offline + redo log or
- Whole database offline backup or
- Whole database online + redo log or
- Whole database online backup
- Generic tape names for database backup
- Database backup profile – usually init<SID>.sap
- Options for ReDo log backup
- Redo log backup
- Generic tape names for database backup
- Options for ReDo log backup
- Partial database offline backup or
- Partial database online backup
- Tablespace names to be included in the back up
- Generic tape names for database backup
- Database backup profile – usually init<SID>.sap
- Check and update optimizer status
- Tablespace names to be included in the statistics run
- Adapt next extents
- Tablespace names for next extents adaption
- Check database
- N\A
- Verify database
- Tablespace names to be verified
- Database backup profile – usually init<SID>.sap
- Cleanup logs
- N\A
- You may now leave the DB13 transaction.
