Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Custom Concurrent Manager issue with cursor

edited Apr 3, 2014 8:26AM in Core Concurrent Processing - EBS (MOSC) 3 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center