I facing the following issue while preparing for OCP
Question:
2 Users are running updates on table and a deadlock comes up.
One user receives the famous ORA000600 deadlock detected error.
What should this guy do to resolve the conflict?
I said: "Well, nothing! There is an automatic detection (and resolution!) of deadlocks - Oracle has figured out that his lock has to be "killed". The statement was rolled back." - so what should he do?
He should wait some time, to make sure the other guy has finished and then try again.
As answer I read he must commit or rollback, otherwise the other statement could not complete.
Did I understood deadlock detection the wrong way?