Update query is hanging
Update query gets fired from my java application, but sometimes the query hangs for hours. When we check using "Show processlist" the status is displayed as updating and we have to restart the database to release it.
Is there any setting by which the long-running queries can automatically disconnect after the specified time?
Subject
Written By
Posted
Update query is hanging
February 17, 2023 12:04AM
Sorry, only registered users may post in this forum.
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.