Search code examples
sqloracle-databaseoracle-sqldeveloper

Oracle database seems to be locked

I have executed the query below in SQL Developer to update a column in a table for all the rows:

update table set column xx = NULL

For some reason after doing it I cant change any value in the database. The same behavior has happened in two different environments.

Is there anything wrong with my query? I have run commit; and rollback; to try to solve the issue with no success. At the moment even if I try to change one simple value in a row it times out.

Perhaps the problem has been caused by a different circumstance but the issue started happening after I run my query.

Thank you in advance!

Solution

  • Thanks all for your suggestions. In the end there was another process using the database heavily which was causing the problem.