This discussion is archived
2 Replies Latest reply: Nov 15, 2012 2:14 PM by Don Seiler RSS

enq: TX - row lock contention when using interactive reports

443762 Newbie
Currently Being Moderated
We are seeing a great number of blocking sessions that are being caused by row locks stemming from this statement:


UPDATE WWV_FLOW_WORKSHEET_RPTS SET UPDATED_ON = :B2 , UPDATED_BY = :B1 WHERE ID = :B3


When does the interactive report fire this update statement? The page averages around .75 seconds per page view.

Legend

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