how to analyze a deadlock on oracle 19c RAC with the trace file ?
========================================================================
Global Wait-For-Graph(WFG) for GES Deadlock ID=[4_0_2]
------------------------------------------------------------------------
Victim : (instance=1, lock=0xf50d4460)
Start (master) Instance : 1
Number of Locks involved : 4
Number of Sessions involved : 2
User session identified by:
{
User Name : Administrator
User Machine : WORKGROUP\WORKAREA
OS Terminal Name : WORKAREA
OS Process ID : 7280:7812
OS Program Name : Toad.exezvtstdb1
Application Name : TOAD 13.3.0.1811le_databaseScript-55.sql>
Action Name : 47016976,335649408,46677664lotesactionave
Current SQL : update mesppt.test set nn=35 where name='WW'
Session Number : 1141
Session Serial Number : 12248
Server Process ORAPID : 147
Server Process OSPID : 14897
Instance : 1
}
waiting for Lock 0xf50d4460 (Transaction):
{
Lock Level : KJUSEREX
Resource Name : TX 0xc0013.0x1e80(ext 0x3,0x5)
GES Transaction ID : 93000-0001-000192CA