sql - Oracle database is hanging infinitly in UPDATE queries

Question

suddenly my update queries are not executing . i can make select queries but when i try to update records the database hangs infinitly. i tried even from sql plus and nothing happens.

Answer 1

Most likely you have another open uncommitted transaction for the same set of records, so they are locked for that transaction.

And, most likely, you locked them, running the same UPDATE in another transaction.

Just Commit/rollback your transactions, you should be fine.