This discussion is archived
4 Replies Latest reply: May 6, 2013 2:03 PM by Sergey Barskiy RSS

Weird update statement when using Entity Framework and ODP

Sergey Barskiy Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points