This content has been marked as final. Show 2 replies
As graph is not posted well. I am just giving that in note format.
In blockers section:
B waits on X
A holds SS
In waiters section:
A waits on SS
B waits on X.
It is hard to tell why this is happening in your environment as we are not aware of what processes (concurrent programs, concurrent requests, APIs, DML statements, ..etc) are running in your instance.
Please see these docs, it should give you an idea on how to start troubleshooting this.
Troubleshooting "ORA-00060 Deadlock Detected" Errors [ID 62365.1]
Bitmap Indexes and Deadlocks: Deadlocks on DML's and DDL's [ID 171795.1]
FAQ: Detecting and Resolving Locking Conflicts and Ora-00060 errors [ID 15476.1]
Concurrent Processing - ORA-00060: Deadlock Detected - UPDATE FND_CONCURRENT_QUEUES [ID 866298.1]