SAP Note 53050 - Resetting of SAP Statement Cache

Component : Informix -

Solution : https://service.sap.com/sap/support/notes/53050 (SAP Service marketplace login required)

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 :

101717Automatic restart of SAP R/3 work processes
64001INFCFGCHECK: Detailed messages of single checks
41360Database configuration using onconfig parameter
38307Reducing shared memory consumption