Re: ctx_ddl.sync_index question

From: Hemant K Chitale <>
Date: Wed, 08 Apr 2009 23:51:04 +0800
Message-Id: <>

'12M' seems to be quite low. That is the memory allocation for the index synchronization.
Values of 50M and 100M and higher wouldn't be unreasonable.

Ensure that you have a job to sync the index frequently.

Monitor the count of pending updates by doing a count on CTX_USER_PENDING;

At 10:25 PM Wednesday, you wrote:
>Redhat linux
>2 cpu
>12 GB ram
>COTS app: kana
>Kana is telling our developer that we need to run
>ctx_ddl.sync_index('kc_ctx_rawtext', '12M'); end;
>to resync the text index.

Hemant K Chitale

Received on Wed Apr 08 2009 - 10:51:04 CDT

Original text of this message