Monitor a Query then retrieve data using process ID
Is there a way to monitor a query to see when it is complete and then retrieve data using the process ID. I have an application that is executing some pretty large queries. What I would like to do is run query, retrieve ID, and monitor the query. When the query is complete I can then use the process ID to request the response back from mySQL. I would like to do this because some queries cause the application to time out as there is no response for several minutes. If I could monitor the query, I could bounce back and forth so the front end does not time out. Thanks
Subject
Written By
Posted
Monitor a Query then retrieve data using process ID
June 22, 2016 02:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.