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

Last updated on FEBRUARY 21, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms