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 and later
Information in this document applies to any platform.


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


  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


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