Custom Concurrent Manager issue with cursor
Hi All,
EBIZ R12.1.3 PCP (2nodes) shared appl_top
DB 11.2.0.2 RAC
we have custom concurrent manager (for running invoices reports) with four process on each node .We monitored that these two managers are not releasing the cursors . Day by day cursors count is increasing and and when it reached the limit , concurrent programs on these managers are giving ORA-1000 errors.
Manager Processes are 4 on each node and with 8 cache size and 10sec sleep time . Type Standard (FNDLIBR) all other properties are same as the Standard Managers
As a workaround we are restarting daily these managers.
please help in this , how to make these managers work normal as other standard managers.