Parameter Value Require

[Former Member]

Hi,

rdisp/wp_auto_restart

Please advise us regards to the above parameter value before tuning.

What is suitable value (Initial value)?

Your immediate response is really appreciated

Thanks

[Former Member · Accepted solution]

Hi,

The value of the parameter is entered in seconds.

The time interval depends to a large extent on the size and the utilization of the system and the perfromance loss which occurs as a result of the loss the cursor cache for the respective database. This is dependent to a large extent on the database and the platform. Appropriate settings are between several days (for example every two days: rdisp/wp_auto_restart 172800) few hours (for example every three hours: rdisp/wp_auto_restart 10800) up to half an hour rdisp/wp_auto_restart 1800).

Check out SAP note 101717 and Note 922007 - Changing the parameter rdisp/wp_auto_restart dynamically

Best Regards

Imran