4 Replies Latest reply: May 6, 2013 4:03 PM by Sergey Barskiy RSS

    Weird update statement when using Entity Framework and ODP

    Sergey Barskiy
      I am getting the following statement periodically issues against my database
      update "MYACCOUNT"."USERS"
      set "SUSERGUID" = :p0 ,"ROWVERSION" = :p1
      where (("SUSERGUID" = :p0) and ("ROWVERSION" = :p1))

      The problem is that USERS table relates to practically all the tables in the database, causing massive locking problems.

      Thank you.