-
HI out there,
i have a Problem with the interMedia Context Server.
After Importing a large Dump 250MB, im about to create an index.
CREATE INDEX AV_STR_VAL ON ATRIBUTEVALUE(STRINGVALUE) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ('Memory 50M');
also tried it with 500M ... but the same Problem:
After a short while the PL Script is hanging and the CPU Load is 100% for the Script. The CTX Log says 1600 documents indexed. Thats it. Nothing else ... No error Message at all.
So is there a way to find out whats going on there? Maybe a Log for what he is really doing.
Thaks alot
P.S: Please if possible post scripts as im no DBA till now :)
-
isn't it better to run a script to create index based on index type?
At least this is the only valid option we know for SDO indextype based indexes.
