Dialog WP runtime exceeds value set in rdisp/wp_max_runtime

[Former Member]

Dialog wp runtime exceeds the value set in parameter rdisp/wp_max_runtime

Value set for rdisp/wp_max_runtime is 1500 but wp runtime exceeds more than 10,000. we are using 4.5B system on Oracle/AIX.

Please suggest how to avoid such wp running for more than value set in parameter rdisp/wp_max_runtime.

[Former Member]

Hi,

Is it possible that the work process is experiencing the scenario described in note 760648 ?

Regards,

Gary

[former_member185954]

Hi Rudra,

rdisp/max_wprun_time essentially may not stop the process all th time especially if your work process is waiting for some information or waiting for some query to execute.

Read the following note which describes the behaviour of this parameter

Note 25528 - Parameter rdisp/max_wprun_time

Hope that helps.

Regards,

Siddhesh

[Former Member]

Thanks for the Note.

[former_member185954]

Hi Rudra,

If your question is answered , please close the question by marking it answered.

Regards,

Siddhesh

[Former Member]

Hi Rudra,

Try setting this value to 0 which is infinite. But here the problem would be when there is really a problem, you will never come to know because the process will go on and on.

Another suggestion would be to debug and check which piece of code takes longer to execute, probably there is a serious problem.

Regards,

Nameeta