2 Replies Latest reply: Nov 15, 2012 4:14 PM by Don Seiler RSS

    enq: TX - row lock contention when using interactive reports

    443762
      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.