title: Deadlocks in Oracle
body: <p>I want to  make a script where the oracle sessions which go into a deadlock are killed automatically.Is it possible to find out the session id  for the sessions which go into a deadlock.As of now I have to bounce the database to remove the deadlock.Is any solution to this problem possible?</p>