RE: ctx_ddl.sync_index question

With sync on commit, only 1 session at a time can sync (see note 249991.1 and oracle docu: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/csql.htm#sthref197), 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.

Regards,

 
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer

<snip>
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>

--
http://www.freelists.org/webpage/oracle-l