“A deadlock can occur when two or more users are waiting for data locked by each other. Deadlocks prevent some transactions from continuing to work.”
That is how oracle concept manual describes Deadlock. Today I encountered an Deadlock. No, no, no… not on the database I support, but on the road!!. Today it rained a lot in Chennai and thus resulted in traffic jams everywhere. I was comming home from office in a narrow road – room for only two small cars to go in parallel. Two small trucks comming against each other got stuck. They can’t move either backward or forward. Luckily, one of the guy showed me a small narrrow road (lane??) which took me to the highway.
“Oracle automatically detects deadlock situations and resolves them by rolling back one of the statements involved in the deadlock”
There was no such thing on the road. I hope someone would have rolled back one of those trucks and solved the deadlock by this time now 
