How To Address Contention on the Counters Table in UCM 10g

(Doc ID 1390961.1)

Last updated on JULY 05, 2017

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


We have session waiting in the UCM repository database.

This query is executed very often
"UPDATE Counters SET dNextIndex = (dNextIndex+:"SYS_B_0") WHERE dCounterName=:"SYS_B_1""
and cause a lot of "wait application" with "enq:TX - row lock contention".

What can be done in UCM configuration to give better performance to the "update counters" process?


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