My Oracle Support Banner

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

Last updated on MARCH 21, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


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.


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
 Ask Questions, Get Help, And Share Your Experiences With This Article
 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

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