Oracle Text: Memory and parallel indexing

Hello

I am using Oracle 10g on Windows 2003 Server.

I have two questions related to Oracle Text:

1. Memory What kind of memory does Oracle Text use to index (Shared pool, large buffer, block buffers...)? I have failed to find the information in the documentation. When running the ctx_ddl.sync_index, I get some errors when specifying a memory parameter that's too large. I have a shared_pool size of 1300M (that I believed were used for indexing), and have 12G in the server (that I have trouble to get Oracle to use, no more than 2G can be used ?!?). The parameters for the sync procedure are: Memory = 100, parallel=4. The errors I receive are:

ERROR at line 1:

ORA-20000: Oracle Text error:
DRG-50610: internal error: drvdml.ParallelDML
DRG-50857: oracle error in drvdml.ParallelDML
ORA-12801: error signaled in parallel query server P000
ORA-20000: Oracle Text error:
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVPARX", line 33
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 539
ORA-06512: at "IDX_TEST.IDX_SYNC", line 21
ORA-06512: at line 1

2. Parallel indexing
Is it true that parallel indexing with ctx_ddl.sync_index only works with the Enterprise edition of Oracle?
I have run some tests on my machine where the performance of running the indexing funciton with the parallel option up to 7. The performance does not increase (or decrease) with any numbers, compared to not specifying any value for parallel on the standard edition of Oracle. When upgrading to Enterprise Edition, the performance increased dramatically. I have not found any help in the Oracle documentation, so I wonder if anybody have encountered the same problem, and reached the same conclusion. I can buy a very great car for the price of upgrading from standard edition to Enterprise edition on a server with 4 CPU's, so I want to be absolutly sure that I need it :)

Hope anyone can help.

Regards,
David Received on Wed Jun 22 2005 - 03:55:19 CDT