Oracle Text indexes Sync Memory [message #598663] |
Wed, 16 October 2013 13:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/be1fb9296b99823dbeae188f07862f0d?s=64&d=mm&r=g) |
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
|
|
|
|