Parameter
rsdb/staton
Short Text
Activate Extended Table Statistics
Parameter Description
Activates extended table access statistics (call statistics) in the performance monitor. The extended table access statistics (call statistics) let you monitor the following, by table: the requests passed by SAP applications to the SAP data base interface; and the resulting data base calls issued by the data base interface to the data base system.
Together with the Setup/Buffer statistics, the extended table statistics are useful for tuning the SAP table buffers (partial and complete table buffer). You should run your system with call statistics activated if you wish to make use of SAP’s Early Watch Program for obtaining optimal performance from your system.
Shared Memory Usage
The extended table statistics are collected in a region of shared memory but are transferred to the performance monitoring data base with the ordinary performance monitoring records. The amount of shared memory allocated is from the NTAB (number of entries in table DDNTT) and is static. No dynamic expansion of the statistics structure is needed.
The statistics in the shared memory region are deleted if the SAP System in which they are being collected is restarted. You should therefore transfer the statistics to the performance monitoring data base before restarting the application server(s) in which the statistics are active.
Use
Tuning (collection of statistics)
Who is permitted to make changes?
Customers.
Operating System Restrictions
All.
Database System Restrictions
All.
Are other parameters affected or dependent?
None.
Are other parameters affected or dependent?
• rsdb/stattime
• ipc/shm_psize_40
• rsdb/stattime : To include access times in the extended table statistics, set the parameter shown above as well.
Values allowed
Acceptable values:
1
Activate extended table access statistics (call statistics).
0
Deactivate collection of statistics.
