Blocking Session which is stuck and cannot remove from the blocking list, even you kill it again and again.

Run Environment file — to connect to the correct database [oracle@erpdb ~]$ . env.sh Launch SQLPLUS as sysdba user [oracle@erpdb ~]$ sqlplus / as sysdba <SQL> select substr(a.spid,1,9) pid, substr(b.sid,1,5) sid, substr(b.serial#,1,5) ser#, substr(b.machine,1,6) box, substr(b.username,1,10) username, — b.server, substr(b.osuser,1,8) os_user, substr(b.program,1,30) program from v$session b, v$process a where b.paddr = a.addr and type=’USER’ and