My Oracle Support Banner

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

Last updated on OCTOBER 09, 2023

Applies to:

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


During performance testing, users are 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:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.