How Does WebCenter Content 11g/12c Use Sequences to Uniquely Identify Content ?
(Doc ID 1395583.1)
Last updated on APRIL 28, 2023
Applies to:Oracle WebCenter Content - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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.
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.
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