Dear Community,
We have a separate connection pool in IIS for ASPOSE. Every time a request is sent by user for workflow we create a new instance of EngineManager and destroy it after completing the task. Since we don't have a proper dispose method in EngineManager, we dispose the instance by assigning it null value. Because of this method the database connections with the EngineManager is not closing properly, which results in high number of open cursors in oracle database.
What is the proper way to dispose off EngineManager's instance? We need to dispose off EngineManager on immediate basis after completing the task so that we can optimally utilize our connection pool.
Currently users are facing delay in their request fullfillment.We have received a report from our DBA that out of all the total database wait time ASPOSE WORKFLOW_LOCK takes up around 97%.
Regards,
Ahsanullah Bughio
