TS Enqueue Deadlock Due to Inmemory Table Repopulation with 'ALTER TABLE TEST EXCHANGE PARTITION' (Doc ID 2770455.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

• ORA-00060 19.6 RAC inmemory populate exchange partition:
  
  ALTER TABLE TEST EXCHANGE PARTITION...
  DEADLOCK DETECTED (id=0x224df40b)

  Chain Signature: 'enq: TS - contention'<='row cache lock' (cycle) >>>>>>>>>>
  Chain Signature Hash: 0xd8b45780

  The following deadlock is not an Oracle error. Deadlocks of
  this type can be expected if certain SQL statements are
  issued. The following information may aid in determining the
  cause of the deadlock.

  Resolving deadlock by signaling ORA-00060

  
  dbgtTrc_int()+140<-kdzalcd_colclck()+2100<-apaReqdColsInMem()+1415<-apaIMCScanPossible()+337<-kkoTbSetColumnar()+368<-kkoiqb
   

Cause

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