RE: ctx_ddl.sync_index question

From: freek D'Hooge <>
Date: Thu, 9 Apr 2009 01:31:12 +0200
Message-ID: <>


With sync on commit, only 1 session at a time can sync (see note 249991.1 and oracle docu:, the other sessions will have to wait. So if you have a high concurrenty of sessions inserting into a table with a text index, the sync on commit can give performance problems due to locking.


Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

We have a COTS application that creates indexes like this:

create index {index_name} on {table_name}({column_name}) indextype is CTXSYS.CONTEXT PARAMETERS('SYNC(ON COMMIT)'); </snip>

Received on Wed Apr 08 2009 - 18:31:12 CDT

Original text of this message