Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ConText Index Maintenance - Optimize Blocking Sync

Re: ConText Index Maintenance - Optimize Blocking Sync

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Tue, 14 Jun 2005 08:55:31 -0400
Message-ID: <-oOdnc7cF4KsTjPfRVn-iA@comcast.com>

"at"@" <""caoimhinocrosbai(at\"@)yahoo.com"> wrote in message news:1118329795.0a7be6b2d48bcf5e9de2fbd8fda9904a_at_teranews...
> Tim Arnold wrote:
>
> >
> > You might try ctxsrv. I know is not the 'supported' way to maintain
> > indexes, but it works
> >
> >
>
> Didn't think to try that... does it work differently to
> sync_index/optimize_index from pl/sql such that blocking will not occur?

Never had a problem w/blocking. I have eight Text Indexes on one table. The supposed problem is index fragmentation - I believe ctxsrv just keeps adding records (which would support the notion of not blocking) Received on Tue Jun 14 2005 - 07:55:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US