My Oracle Support Banner

ITEM_CTX_IDX and REV_CTX_IDX Fragmentation Is Still High After Database Reorg (Doc ID 2236230.1)

Last updated on AUGUST 03, 2021

Applies to:

Oracle Agile PLM Framework - Version 9.3.3.0 and later
Information in this document applies to any platform.

Goal

Actual Issue
Domain Index ITEM_CTX_IDX and REV_CTX_IDX fragmentation is high even after performing database reorg.

Steps

  1. Stop All Application Server
  2. Perform database reorg as mentioned in <Note 1528494.1> - Agile 9.3.2 Database Reorg Process
  3. Check the Domain Index fragmentation

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
References


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