APEX

Hi

We are using APEX 5.1.1.00.08 on RDBMS 12.1.0.2 with various web browsers.

During testing of our rewritten App we are seeing in DBA_HIST_ACTIVE_SESS_HISTORY: -

enq: TX - row lock contention

for very short periods for the query: -

SELECT ID, REPORT_TYPE FROM WWV_FLOW_WORKSHEET_RPTS

WHERE WORKSHEET_ID = :B5

AND APPLICATION_USER = :B4

AND (BASE_REPORT_ID = :B3 OR (NVL(:B3 ,0) = 0

AND NAME IS NULL))

AND SESSION_ID = :B2

AND SECURITY_GROUP_ID = :B1 FOR UPDATE

The length of time these locks are held is negligible but the frequency is worrying, we are looking to put our application live with APEX 5.1.1 very soon and would like to resolve this if possible.

Can anyone anyone help with a diagnosis and/or cure for this please?

Regards

Steve