1 Reply Latest reply on Jun 3, 2014 6:29 PM by jgarry

    Content Index - slow index sync on COMMIT

    2658687

      Hi experts,

       

      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.

      We are planning to implement the index optimization (CTX_DDL.OPTMIIZE_INDEX) in our database with threshold: % of fragmented row in our table. 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?

      We read somewhere that $N and $I table is only for garbage collection purpose. Can the garbage volume (# of record in $N or $I ) be the alternative threshold value to trigger the optimization process?


      Thanks in advance.


      CW