In OracleText, a full-text index can be configured to synchronize manually, at regular intervals or on commit. By default, the Blueriq full-text index on aggregates and documents is synchronized every hour. To change this behavior, the index needs to be rebuilt with different parameters.
Always consult the documentation of your particular Oracle database version. The following examples illustrate how to change the synchronization behavior without setting additional options such as whether the index is rebuilt online or offline, whether it is rebuilt in parallel, etc.
Please note that each index synchronization increases the index fragmentation, degrading search performance over time. Consult the How to maintain full-text search performance article to learn more about index fragmentation and how to maintain the full-text index.
We advice to rebuild the index after every change. This can be done using the following script:
alter index aq_fulltext_index rebuild;
Changing index synchronization to manual
To change the index synchronization to manual execute the following script:
ALTER INDEX aq_fulltext_index REBUILD PARAMETERS ('REPLACE METADATA SYNC (MANUAL)');
When changing the full-text index to manual synchronization, any modification to aggregates and documents will not be reflected in the index until the stored procedure CTX_DDL.SYNC_INDEX is not manually called. This has to be done by DBA either manually, or through a scheduled job.
Changing index synchronization interval
To change the index synchronization to a regular interval, execute the following script:
ALTER INDEX aq_fulltext_index REBUILD PARAMETERS ('REPLACE METADATA SYNC (EVERY "sysdate+1/24")');
The "1/24" expression represents one twentyfourth of a day (one hour). The expression uses Oracle's job scheduling syntax.
When using this synchronization method, the database user needs to have the CREATE JOB system privilege.
Changing index synchronization to on commit
To change the index synchronization behavior so that the index is synchronized after every commit, execute the following script:
ALTER INDEX aq_fulltext_index REBUILD PARAMETERS ('REPLACE METADATA SYNC (ON COMMIT)');
When this synchronization method is used, the index is updated every time an aggregate or document is created, modified or deleted.
Overview
Content Tools