Database Administration (MOSC)

MOSC Banner

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center