From the report /SDF/OI_ADMIN, you can collect the table call statistics (ST10) and report execution statistics based on the Usage and Procedure Logging (UPL) for one week on an hourly basis. It saves the results in the tables /SDF/OI_REPSTAT and /SDF/OI_TABSTAT.
The average values per hour are saved in the tables /SDF/OI_REPSTATS and /SDF/OI_TABSTATS. This allows you to identify the time with lowest workload within a week for a particular set of critical objects. This information is also used by the Online Import Check (report /SDF/CMO_TR_CHECK).
Usage & Procedure Logging
The Usage and Procedure Logging (UPL) must be activated as a prerequisite for the data collection. You see if the UPL is already running or not. If it is not yet running you can press the button “Control UPL” to navigate into the UPL activation screen.
Control Usage Statistics
In order to activate the data collection for the usage statistics you must press the button “Collect data”. This creates a background job which runs on an hourly basis – short before each full hour. The collection automatically ends after one week. A traffic light symbol indicates if the data collection is already running. Then you cannot start another job. You also see the amount of usage data which was already collected. A value of 100% means that usage data is available for a complete week (168 hours).
Display Usage Statistics
In this section you can display the usage statistics.
- Table calls (avg): You see the average number of table accesses table changes per hour for all tables. If you click on a particular table you see the values only for this table for the whole week.
- Table calls (det): You see the number of table accesses table changes per hour for all tables and for all hours of a week. If you click on a particular table you see the values only for this table.
- Report calls (avg): You see the average number of report execution steps per hour for all reports. If you click on a particular report you see the values only for this report for the whole week.
- Report calls (det): You see the number of report execution steps per hour for all reports and for all hours of a week. If you click on a particular report you see the values only for this report.
