SELECT blocks UPDATE
PL/SQL Release 10.1.0.4.0 - Production
Standard Edition
We got complaints from the users that an application blocked.
When we queried v$lock we found that a SELECT statement was blocking an UPDATE statement!
To resolve the problem I killed the process that issued the SELECT statement.
It was a plain SELECT statement, no SELECT ..FOR UPDATE.
How can this happen?
We got complaints from the users that an application blocked.
When we queried v$lock we found that a SELECT statement was blocking an UPDATE statement!
To resolve the problem I killed the process that issued the SELECT statement.
It was a plain SELECT statement, no SELECT ..FOR UPDATE.
How can this happen?
0