Re: ctx_ddl.sync_index question

From: Yong Huang <>
Date: Thu, 9 Apr 2009 10:42:56 -0700 (PDT)
Message-ID: <>

> is it so resource intensive that the system
> will essentially lock (from the users viewpoint)


Others had excellent answers. I want to point out the locks taken during the sync_index operation. My earlier test (in shows that "All TM locks are in mode 3. So there shouldn't be conflict with DML." See

If the index were ctxsys.ctxcat type, you wouldn't need to run sync_index. But ctxsys.context type does.

Yong Huang       

Received on Thu Apr 09 2009 - 12:42:56 CDT

Original text of this message