Skip to Main Content

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!

the creation process is slow - can I create an context index online version

user12287154Nov 15 2010 — edited Nov 15 2010
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');
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2010
Added on Nov 15 2010
5 comments
1,208 views