Row Lock Contention Updating Rows In WC_NAVIGATION_ACTIVITY (Doc ID 1954421.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle WebCenter Portal - Version 11.1.1.8.4 to 11.1.1.8.4 [Release 11g]
Information in this document applies to any platform.

Symptoms

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:

 

Cause

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