How to remove/delete DeadLocks(ORACLE DB)

[Former Member]

  Deleting Database DeadLocks on ORACLE

Reason

    you want to delete database deadlock which is interrupting your work

Note

  A deadlock is a situation in which two or more competing actions are each waiting for the other to finish, and thus neither ever finishes.

Example scenario

Backgound job RSLDAPSYNC_USER is scheduled at same time of the day twice.

both the events tries to access the same table USR02 at same instant and waits for the other to finish first

then there are most likely chances for a DB deadlock to be created.

Caution

This must me performed with utmost consious.

procedure

login into the server

login into SQL

And run the following commands,

SQL> select inst_id,sid,serial# from gv$session where username='username';

    INST_ID        SID      SERIAL#
--------------      ---------     -----------
          1              130            620

SQL> alter system kill session '130,620,@1';

Thus, you have successfully deleted DB Deadlock.