My Oracle Support Banner

Reports for Determining the State of Indexes in UCM when Using Zone Fields, DATABASE.FULLTEXT or OracleTextSearch (Doc ID 1338849.1)

Last updated on APRIL 04, 2024

Applies to:

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

Goal

UCM uses a type of index on the Oracle Database called a CONTEXT index, which is part of the database component known as Oracle Text.  Reports on these types of indexes are available and can be useful in determining the state of the index.  CONTEXT indexes are used in UCM for the following search components:
1. Zone Text Fields - for zone fields, an Oracle Text CONTEXT index is placed on an individual metadata field. These are enabled through the component DBSearchContainsOpSupport.
2. SearchIndexerEngineName=DATABASE.FULLTEXT - when this option is used as the UCM search index, the extracted full text of content items is stored in a CONTEXT index. 
3. SearchIndexerEngineName=OracleTextSearch - when this option is used as the UCM search index, both metadata and full text are stored in a CONTEXT index. 
 

Metadata

Fulltext

Zone x (one field)  
DATABASE.FULLTEXT   x
OracleTextSearch x (all fields) x

Solution

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
Goal
Solution
 Determining the index name in use for DATABASE.FULLTEXT and OracleTextSearch
 Determining the index names of Zone Text Fields
 Oracle Text Procedures
 create_index_script
 describe_index
 token_info
 index_size
 index_stats
 optimize_index
References

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