Deleting Database DeadLocks on ORACLE
you want to delete database deadlock which is interrupting your work
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.
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.
This must me performed with utmost consious.
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.