to kill blocked process in oracle

suppose you know the session id which is blocking you program. you can kill that process using this.

select spid from v$process where addr in (select paddr from v$session where sid = 130)
and then execute

kill -9 spid

or
Suppose you know the session name or user name which is blocking you can kill that process like this.

select '!kill -9 ' spid from v$process where addr in ( select paddr from v$session where username='AHSAN_DEV');

this will give list of all process ids to be killed that is blocking, execute them one by one...

Sphere: Related Content