Re: ctx_ddl.sync_index question
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: ganstadba@xxxxxxxxxxx
- Date: Wed, 08 Apr 2009 23:51:04 +0800
'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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
