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 -> ORACLE CONTEXT DML-RSS.

ORACLE CONTEXT DML-RSS.

From: Robert Silver <rss_at_ddsc.com>
Date: 2 Oct 2001 07:59:21 -0700
Message-ID: <259cff91.0110020659.47b85555@posting.google.com>


In an effort top fix some problems we experienced on the server yesterday I came accross this:

it is exactly how Oracle recomends that you do it. Even to the point of
truncating those tables. If you submitted this job as a batch job through
the Context Admin utility you also need to execute dbms_job.delete to delete
the job otherwise it will forever stay in the job cue and will never stop
running.

The context server needs to be better understood. Obviously the stalling problem we have with PPXCASE is local to that

Here is why I think maybe a step or two was missed:

Hindy if you are out there please reply! Anyone else would be welcome as well.

Again on an NT/Oracle 8.05 server the context engine server DML stalled on
a queued job. What would cause such a stall and how do possibly resolve it.
Is there any special diagnostics anyone can suggest?? Any help here would be appreciated. Also How do I know I cleaned out all the garbage are the folowing tables all that are involved:

drq_pending
drq_batches
drq_batchno
ctx_policies

I do not understand the roll the following two play?? ctx_svcq
drq_waiting

Any help in debuging this problem would be greatly appreciated If anyone is aware of any character sequences or characters that cause this
stalling please let me know as well.
I would be willing to pay for a good answer to this problem myself. I am being
abused by users please help!

They have nasty fangs and sharp teeth!! Received on Tue Oct 02 2001 - 09:59:21 CDT

Original text of this message

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