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.
I'm seeing similar issues. APEX 4.0.2.00.07 on Oracle 10.2.0.5. App sessions holding locks on WWV_FLOW_WORKSHEET_RPTS that either block other app sessions or block the ORACLE_APEX_PURGE_SESSIONS scheduler job.