Re: 1205 Lock Wait Timeout on heavy SELECT load?
We got an admin to pull engine status for us. Everything looks very normal, even when the problem is manifesting.
One other weird thing is that we have the default of 50 seconds for lock timeout, but we're getting 1205s 17 seconds after submitting a query.
Subject
Views
Written By
Posted
2989
December 20, 2016 12:24PM
1299
December 20, 2016 12:53PM
1273
December 22, 2016 07:40AM
1038
December 22, 2016 11:45AM
1137
January 12, 2017 09:32AM
1029
January 12, 2017 12:27PM
Re: 1205 Lock Wait Timeout on heavy SELECT load?
1071
February 06, 2017 12:13PM
988
February 21, 2017 09:23AM
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.