ENQ : TX ROW LOCK CONTENTION

Hi,

I have a two node RAC running Exadata. Our ETL datastage is issuing the following update statement with four simultaneous sessions (possibly spawned at the same time)

and getting locked forever. No trace files for a deadlock. I can understand tx row lock contention in certain cases. But this update is purely based on the primary key

UPDATE SF_SERVICE_STG_TEMP.SERVICE_ACCOUNT_CDC

      SET RLSHIP_FRST_NAM = :RLSHIP_FRST_NAM,

          EMAIL = :EMAIL,

          CDC_STAT_CDE = :CDC_STAT_CDE,

          ETL_UPDATE_CYCLE_ID = :ETL_UPDATE_CYCLE_ID,

          ETL_UPDATE_DTE = :ETL_UPDATE_DTE,

          MID_GROUP = :MID_GROUP,

          MID = :MID,