Managing DML Operations for a CONTEXT Index

Viewing Pending DML:
SELECT pnd_index_name, pnd_rowid, to_char(pnd_timestamp, 'dd-mon-yyyy hh24:mi:ss') timestamp FROM ctx_user_pending;

Synchronizing the Index:
The following example synchronizes the index with 2 megabytes of memory:
begin
ctx_ddl.sync_index('myindex', '2M');
end;

You can set CTX_DDL.SYNC_INDEX to run automatically at regular intervals using the DBMS_JOB.SUBMIT procedure.The location of this script is:

$ORACLE_HOME/ctx/sample/script/drjobdml.sql

you must be the index owner and you must have execute privileges on the CTX_DDL package. For example,to set the index synchronization to run every 360 minutes on myindex,

SQL> @drjobdml myindex 360