Database Tuning (MOSC)

MOSC Banner

how to analyze a deadlock on oracle 19c RAC with the trace file ?

in Database Tuning (MOSC) 1 commentAnswered

========================================================================

 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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center