How to Diagnose Different ORA-00060 Deadlock Types Using Deadlock Graphs in Trace
(Doc ID 1559695.1)
Last updated on MARCH 21, 2022
Oracle Database - Enterprise Edition - Version 22.214.171.124 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!