My Oracle Support Banner

How to Diagnose Different ORA-00060 Deadlock Types Using Deadlock Graphs in Trace (Doc ID 1559695.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.

Goal

This article should be used in conjunction with :

 <Document 1507093.1> How to Identify ORA-00060 Deadlock Types Using Deadlock Graphs in Trace

to identify and diagnose various common types of deadlocks. See the article above for information about how to read Deadlock Graphs in trace files before using this document to identify the different types.

If you are not already using it, you can use the Troubleshooting Assistant to help you diagnose common ORA-00060 Deadlock issues:

<Document 60.1> Troubleshooting Assistant: Oracle Database ORA-00060 Errors on Single Instance (Non-RAC) Diagnosing Using Deadlock Graphs in ORA-00060 Trace Files

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 Ask Questions, Get Help, And Share Your Experiences With This Article
Solution
 Signature:TX Lock Requesting Mode X (6)(TX X X)
 Indicative of: Application Deadlock
 Signature: TM Lock Requesting Mode SSX (5) (TM SX SSX SX SSX)
 Indicative of: Missing Index on Foreign Key (FK) Constraint
 Signature: TX Lock  Requesting Mode S (4) (TX X S)
 Indicative of: Bitmap Index
 Indicative of: Insufficient Interested Transaction List (ITL) Provision
 Indicative of: Manipulation of Primary / Unique Key Index data in an inconsistent order
 Signature: Single TX X X Row in Deadlock Graph 
 Indicative of: Self Deadlock (Autonomous Transaction)
 Indicative of: Self Deadlock (No Autonomous Transaction)
 No Matching Signature/No Deadlock Graph
 Discuss ORA-00060 Deadlocks
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.