I have a database deadlock problem with my Oracle DB server. The
deadlock occurs on one of the table.  The deadlock's produced by one
of the operations of hundred of applications connecting and hitting
that DB server, so it is not easy for me to detect the source of
deadlock (from which application on which machine).  My question is
are there any monitoring tool available so that I can plug in between
my applications and that DB to trace the root cause of the deadlock in
my application code?