Solution : https://service.sap.com/sap/support/notes/53050 (SAP Service marketplace login required)
Summary :
SAP Note addresses shared memory bottlenecks on database machines, primarily due to the prolonged retention of memory by large database sessions within the SAP statement cache. The solution involves adjusting two key parameters to manage the reset behaviors of the SAP statement cache: 'dbs/inf/reset_cache_threshold' and 'dbs/inf/reset_cache_interval'. These parameters are critical for defining the size threshold and timing for memory checks and resets in SAP Work Processes. Implementation should be approached carefully to avoid masking underlying issues and should follow specific configurations as outlined in related SAP notes. Prior versions should refer to Note 101717 for guidance.
Key words :
database machine shared memory bottlenecks occur, /dbs/inf/stmt_cache_reset_time =3600/dbs/inf/stmt_cache_reset_size =5000000, additional key words cursor cache, sap statement cache takes place, unusually large database sessions, database session temporarily requires, sap work process requires, dbs/inf/stmt_cache_reset_size, dbs/inf/stmt_cache_reset_time, dbs/inf/reset_cache_thresholdas
Related Notes :
| 101717 | Automatic restart of SAP R/3 work processes |
| 64001 | INFCFGCHECK: Detailed messages of single checks |
| 41360 | Database configuration using onconfig parameter |
| 38307 | Reducing shared memory consumption |