View and remove blocked sessions in Oracle

View and remove blocked sessions in Oracle

For more information about how to view and remove Oracle blocking sessions, here we will only talk about the operation steps, not the principles.

Session 1 update object ticket not submitted

When Session 2 is updated, it is blocked because it waits for the tx lock of the session1 lock to update the row.

When Session 3 is updated, the tx lock waiting for the session1 lock to update the row is also blocked.

The root cause of the problem can be obtained through the following query.

We can see that both sid 100 and sid 33 are requesting the tx lock in mode6 (exclusive mode) and are in a blocking queue.

For more details, please continue to read the highlights on the next page:

1 2 Next Page