Home » Server Options » Text & interMedia » Oracle Text indexes Sync Memory (Oracle 11G)
Oracle Text indexes Sync Memory [message #598663] Wed, 16 October 2013 13:16 Go to next message
Messages: 14
Registered: June 2013
Junior Member

We have a procedure where we insert records into a partition of a table on which local context indexes have been built.

Then we call the ctx_ddl.sync_index procedure to sync the inserted records.

The sync_index_procedure accepts memory as an input argument.

From what I have seen, the higher the memory that I give, the quicker the sync takes place.

For e.g. if I give 500M, a sync of a partition containing 8 million records takes about 2 hours. If I give 250M, then the sync takes about 4 hours.

How do I determine what is the optimum memory argument that needs to be supplied to thsi procedure.

Re: Oracle Text indexes Sync Memory [message #598784 is a reply to message #598663] Thu, 17 October 2013 13:33 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
Set it as high as you can without causing paging. Please see the section of the online documentation below for details.

Previous Topic: Oracle Text and Reserved Words
Next Topic: Domain index >stemming concept
Goto Forum:

Current Time: Sun Aug 14 16:55:26 CDT 2022