Many ORA-00060 Deadlock on 19.15
Running 19.15 on Solaris Sparc 64 and getting lots of deadlocks
Tried to identify statements involved, thought I had what it was, but then it seemed not to be the case. I was checking the trace file once more, and found many different statements.
But, for a deadlock, I would expect just 2 statements. Or maybe more like 3 or 4 in a very bad case, but the trace file is listing lots of statements. If the session hangs because of a deadlock, why is it running other statements ? And if they do, how do they relate to the deadlock ?