slow index sync on COMMIT

Hi all,

I'm having slow performance on synchronizing the content index on COMMIT.

DB version: 11.2.0.3

Index Type: Text Index - CTXSYS.CONTENT

Sync mode: on COMMIT

In average, we got 10k to 20k records being update in each COMMIT.

To optimize it, we are planning to implement the index optimization (CTX_DDL.OPTMIZE_INDEX) in our database, and set a % value of fragmented row as a threshold to trigger the optimization process.

But somehow, running the index analysis is also time consuming.

Apart from high fragmented row, does the higher number in DR#...$I/N affects the the sync performance too?