How Does WebCenter Content 11g/12c Use Sequences to Uniquely Identify Content ? (Doc ID 1395583.1)

Last updated on JULY 20, 2024

Applies to:

Goal

In WebCenter Content 11g/12c, database sequences are used to uniquely identify content items, workflows, refinery jobs, and other database objects.  In 10g, the Counters table was used.

WebCenter Content in 11g/12c uses sequences in the database to improve performance in obtaining unique values.

Explanation

Earlier in the product, Content Server 7.x and Webcenter Content 10g, the Content ID value was stored directly in the database, and each time a document was checked in, the value was increased by 1.  

That worked great for systems with low volume, but proved to be a bottleneck on systems that were checking in large numbers of documents at the same time.  

To fix this, sequences were implemented.  

The Content Server will now reserve a pool of ID's and assign them, as documents are checked in.  

When the pool runs out the database will request the next set of numbers, etc.   The default is 200 numbers in a pool, and can be 400 in some cases.

Solution

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