Row Lock Contention Updating Rows In WC_NAVIGATION_ACTIVITY
Last updated on APRIL 25, 2017
Applies to:Oracle WebCenter Portal - Version 188.8.131.52.4 to 184.108.40.206.4 [Release 11g]
Information in this document applies to any platform.
During performance testing, users experience very slow performance navigating the WebCenter Portal site with 50 concurrent users.
Pages are taking up to 50 seconds to load. WebLogic server is showing an increase in the Hogging Thread Count.
During this performance test, it was found that the table WC_NAVIGATION_ACTIVITY had a lot of "enq: TX - row lock contention" wait events. After sometime, the database sessions all complete their update on the table WC_NAVIGATION_ACTIVITY.
Database Analysis of performance test:
- Sessions were running via ‘anonymous’ application user.
- The sessions were getting queued up one after the other and were constantly stuck on ‘enq: TX - row lock contention’ wait event. This was because all of them were trying to run the below update statement:
- The SQL statement above will try to update all records for a specific user_id (in this case ‘anonymous’) in the WC_NAVIGATION_ACTIVITY table, causing Row Lock Contention for all the other sessions that are connected as ‘anonymous’ user.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms