Procedure as Concurrent Request is running for long time where as the same procedure is completing f
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.