Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Text index grows for every synchronize

haarseOct 5 2016 — edited Oct 12 2016

Hi,

We have a text index that becomes total 166 MB upon creation (using Ctx_Report.Index_Size).

If I touch every row in the table and synchronizes all rows in the index again, it becomes 275 MB in size.

It is round 65% increase of the size.

Is this increase expected while synchronizing the same rows?

/Håkan

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 9 2016

Added on Oct 5 2016

#database-key-features, #text

14 comments

2,424 views