Core Concurrent Processing - EBS (MOSC)

MOSC Banner

Procedure as Concurrent Request is running for long time where as the same procedure is completing f

edited Mar 27, 2014 11:36AM in Core Concurrent Processing - EBS (MOSC) 5 commentsAnswered

Hi,

We have a procedure develop by our Apps Tech. When he is running the procedure from Sqlplus or Toad, it is completing very soon (approx 3 min). The same procedure when it is registered as a concurrent program and running, it is taking very long time to complete (approx 80 min).

Even when the the concurrent program is run it is taking huge temp tablespace where as the same procedure when it is run from Sqlplus or Toad is not at all consuming the Temp tablespace.

Kindly advise.

Regards,

Consultant.

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