My Oracle Support Banner

<OWNER>.CAT_TAGS Index Continuously Increase in Size (Doc ID 3012558.1)

Last updated on MARCH 25, 2024

Applies to:

Oracle Text - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Output from weekly reports from CTX_REPORT.INDEX_SIZE shows the Oracle Identity Manager's (OIM) CAT_TAGS index is growing continuously despite the regular execution of the CTX_DDL.OPTIMIZE_INDEX maintenance operation.  Particularly, the index's <owner>.DR$CAT_TAGS$I and the <owner>.DR$CAT_TAGSN tables are growing rapidly into GB in size, for example 40GB and 10GB respectively, and increasing.

To address the high disk usage, the index is dropped and recreated via OIM's index rebuild procedure found in Note.2542823.1.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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