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


Other related posts: