Re: Oracle Text: Memory and parallel indexing

I might have found the answer for question 1. It seems that the memory used is outside the scope of all the memory buffer settings in Oracle. So when I set the buffers to use all the 2G memory available on Windows, the indexing process is unable to allocate the memory it needs (and that I specify that it can take), and a lot of different errors happends.
When minimizing the shared pool and block buffers, so enough memory is available, the indexing runs fine :)

If anyone know the answer to question 2, I would greatly appreciate it.

/David

"Server Applications" <NoSpam_at_dk.dk> wrote in message news:42b92746$0$260$edfadb0f_at_dread12.news.tele.dk...
> 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 - 06:04:35 CDT