My Oracle Support Banner

ORA-00060 Deadlock Graph with >1 Row, at Least 1 Row is Type "TM" with Waiter Waiting for Mode "SSX" Typical Graph Row: "TM SX SSX SX SSX" (Doc ID 1552169.1)

Last updated on OCTOBER 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document is designed to be used in conjunction with guided activities with issue identification as explained in:

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

 

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
Solution
 Indicative of: Missing Index on Foreign Key (FK) Constraint
 What to do with this information:
References

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