Solution : https://service.sap.com/sap/support/notes/586824 (SAP Service marketplace login required)
Summary :
This SAP Note addresses memory issues on database servers, specifically affecting Oracle version 8.1.7. Swapping occurs because the system fails to release memory post-database transactions, with particular prominence in Business Information Warehouse (BW) systems where database processes consume substantial memory due to sorting, hashing, and bitmap operations. The prescribed solution is to regularly restart SAP work processes to ensure efficient memory allocation, regulated by the parameters rdisp/wp_auto_restart and rdisp/noptime. This action terminates and reinitiates both the work and database processes, preventing interruptions in application flow. SAP recommends settings of 28800 seconds for rdisp/wp_auto_restart and 30000 for rdisp/noptime to optimize performance.
Key words :
system writes syslog entry r47, sap profile parameters rdisp/wp_auto_restart, business information warehouse system, processes check timer wp_auto_restart, - rdisp/noptime = 30000if required, sap work processes cn, sap work processes regularly, terms rdisp/wp_auto_restart, performance reasons ensure, parameter rdisp/noptime
Related Notes :
335230 | ORA-4030 with NT and Business Information Warehouse |
101717 | Automatic restart of SAP R/3 work processes |