阻塞根源是39rcgtzqrnbs1 —SQL*Net message from client，还是4kqcuh7s87v5y—enq: TX - row lock contention。

merge into t_Cc_Structure s using (select -1 as DimSubjectid, -1 as DimAccountid from dual) s1  on (s.DimSubjectid = s1.DimSubjectid and s.DimAccountid = s1.DimAccountid) when matched then update set s.structureid = s.structureid when not matched then Insert (structureid, DimSubjectid, DimAccountid) Values (-1, -1, -1)

复制