How to find out the deadlock (as detail as possible!) happened in Oracle 10g and 11g?
tools can be suggest ..
the oracle will automatically kill the victim? what is the victim choice condition ?
what is the process to email the result out as the alert so that all deadlock information can be send to developers and DBA?
information should contain:
1) Time of the deadlock
2) Application the own that process.
3) Host the process comes from.
4) the login the process use.
5) which one is the Victim get killed.
pleaes briefing explain the deadlock process oracle will handle.