Re: Monitor a Query then retrieve data using process ID
> some queries cause the application to time out as there is no response for several minutes
Consider turning o the slow query log, say for queries that take more than 5 secs, and optimise the queries it reports by running Explain on them, building covering indexes for them, using some of the new optimisations &c.
Subject
Written By
Posted
Re: Monitor a Query then retrieve data using process ID
June 23, 2016 08:27AM
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.