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
sherlocksher
Messages: 14
Registered: June 2013
Junior Member
Hi,

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.






Thanks,
Vijay
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: 9077
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.

http://docs.oracle.com/cd/E16655_01/text.121/e17748/aoptim.htm#CCAPP9274
Previous Topic: Oracle Text and Reserved Words
Next Topic: Domain index >stemming concept
Goto Forum:
  


Current Time: Thu Mar 28 17:31:02 CDT 2024