Oracle Text (MOSC)

MOSC Banner

Can I parallelize the sync (on commit) of a locally partitioned Oracle Text index?

edited Aug 9, 2012 6:21PM in Oracle Text (MOSC) 2 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center