Re: ctx_ddl.sync_index question

'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:
>10.2.0.4
>Redhat linux
>2 cpu
>12 GB ram
>COTS app: kana
>
>Kana is telling our developer that we need to run
>begin
>ctx_ddl.sync_index('kc_ctx_rawtext', '12M'); end;
>to resync the text index.
>
>
>
>

Hemant K Chitale

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