Use this parameter to have the database perform the wait period for a client to send the next request as a series of shorter wait periods. This parameter changes the wait from one long wait period to shorter wait periods, so that a thread can be canceled if needed.

This parameter is not applicable to Planning Analytics Engine.

Parameter type: optional, static

The parameter is enabled by default.

By default the server can wait for a long time for input, which can result in long-held threads and other problems.

This parameter instructs the Planning Analytics database to perform the wait as a series of repeated shorter waits and gives the database the opportunity to cancel or pause the thread. When set to zero (the default) the legacy behavior of one long wait is used.

Default value: 0