Can I parallelize the sync (on commit) of a locally partitioned Oracle Text index?
I have a locally partitioned table with an associated locally partitioned context index. In testing i can see that the actual commit synchronization does one partition at a time. And, with 24 partitions, this takes a lot of time.
Is there any way to parallelize this to do 4 or 6 at a time like on the original context index build? Or, should I just create each partition with differing sync (every nnn) settings?
Any advice would be appreciated.
0