1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Workprocess getting into Reconnect Status

Friday, 07 February 2014 13:24

Written by Prakash Palani

Print E-mail

 

1. Jobs got into active status when we started the jobs manually and all the subsequent jobs ran successfully.

2. After sometime, if the system is idle and not processing any jobs, then all the subsequent jobs will get into ready state again.

Resolution : From the analysis, we could see that the IDLE_TIME (at Oracle Level) parameter was set to 30 which means that all the idle sessions which are crossing this limit will get disconnected, as a result, all the workprocess will get into reconnect status.  In order to resolve the issue, we have changed the IDLE_TIME parameter to UNLIMITED post which the issue got resolved.

Thanks

PrakashP

Workprocess getting into Reconnect Status