Re: Context Cartridges

Thanks for the response.
Basically the policies are direct data stores of plain ASCII text data with mostly default settings (I added a definition). The indexes are basically the same -- default settings.
I agree with you on the trace files, altho I am sure Oracle support will want to see them :-).
I guess the approach I could take would be to build my own trigger to reindex when an insert, update or delete takes place, because from what I have been told
Context doesn't reindex correctly (or at all) anyhow when it needs to. However, I don't really feel comfortable taking that approach either, because I would rather do the
reindexes in batches to avoid fragmentation.

I'll see what Oracle discovers, and see if I can narrow down a little further when the DML server dies. One thing I do notice, and this could be my problem???, is that
there is a pending reindex in the CTX_ALL_DML_QUEUE. I am not able to clear that out.....but the policies and indexes do exist. Ideas? Thanks again.

Rod Stewart wrote:

> I have found in the past that policies using certain filter types (in
> particular MS Word) have a greater propensity to kill the DML server. Have
> you ascertained whether the DML server is acting on a particular
> policy/index when it dies? What do your policies look like?
>
> Speaking from experience, you may well find that looking at the trace files
> etc won't do you much good either, they don't contain great amounts of
> detail where context is concerned, but may help you to confirm any
> suspicions you have.
>
> Rod J. Stewart
>
> kiss <ks_at_yahoo.com> wrote in message news:37D6BEDB.5EC309DF_at_yahoo.com...
> > We have Context Cartridges running on Solaris 2.7 Oracle 8.0.5.
> > Recently the dml personality started dying for no apparant reason.
> > When trying to restart it, it won't start until the dmltrig package is
> > recompiled.
> > After, the dml personality will start, but only for a short period of
> > time, and then it dies again.
> > Nothing is in the general Oracle error log, and Context only has the
> > install log.
> >
> > I've re-ran the dml package creation scripts, and even re-installed
> > Context Cartridges to no avail.
> >
> > We have close to 1.2 GB's of memory allocated for this instance, with
> > nearly 597 MB for shared_pool.
> >
> > Haven't ran sql trace yet, but most likely will/should.
> >
> > I've called Oracle Support, and they are looking into it, but thought I
> > would post to get others ideas as to what could be wrong, and what to
> > look for.
> >
> > Thanks in advance.
> >
> >
> >
Received on Thu Sep 09 1999 - 12:02:17 CDT