the creation process is slow - can I create an context index online version
I'm in the process of creating a context index. The process is painfully slow. While I was in the index creation process users could not insert/update/delete into the table. I had the "online and parallel" parameters set. Yet must have ignored the online parameter.
Any ideas how to get it to accept the online parameter on the create? Below is my DDL.
Any ideas as to how to make this work and speed this up would be appreciated. The host has 8 cpus and 128 GB of memory.
begin
ctx_ddl.drop_preference('mystore');
end;
/
begin
ctx_ddl.create_preference('mystore', 'BASIC_STORAGE');
ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE',
'tablespace ecpd_blob_index storage (initial 1M)');
ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE',
'tablespace ecpd_blob_index storage (initial 1M)');
ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE',
'tablespace ecpd_blob storage (initial 1M) lob
(data) store as (disable storage in row cache)');
ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE',
'tablespace ecpd_blob_index storage (initial 1M)');
ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE',
'tablespace ecpd_blob_index storage (initial 1M) compres
s 2');
ctx_ddl.set_attribute('mystore', 'P_TABLE_CLAUSE',
'tablespace ecpd_blob_index storage (initial 1M)');
end;
/
commit;
CREATE INDEX ecpdtbls.CONTRACT_DOCUMENT_IX5 ON ECPDTBLS.CONTRACT_DOCUMENT(DOCUM
ENT) INDEXTYPE IS CTXSYS.CONTEXT online parallel 6
PARAMETERS ('storage mystore FILTER CTXSYS.AUTO_FILTER SYNC (EVERY "SYSDATE+1/48
") MEMORY 1024M');