RE: ctx_ddl.sync_index question
- From: "freek D'Hooge" <freek.dhooge@xxxxxxxxx>
- To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <ganstadba@xxxxxxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Apr 2009 01:31:12 +0200
Thomas,
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@xxxxxxxxx
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>
--
//www.freelists.org/webpage/oracle-l
Other related posts: