Re: ConText and soundex

If you have a system that you can treat freely as you wish, you could hit the context servers with a bind variable dump command, and see what they are doing as the query comes in:

svrmgrl
connect internal
oradebug setospid {process id of ctxsrvx shadow} oradebug event 10046 trace name context forever, level 4

Do this on each query server, then fire in your query.

The trace files get very big, very quickly, so restart the servers (or hit them with
oradebug event 10046 trace name context off very soon afterwards).

Trace through the trace files looking for lines like:

select from DR_0nnnn_XXX
where word_text in
(:b0, :b1, :b2, :b3....:b39)

(where XXX is the tag for the soundex index: it's not the usual I1T, but I can't remember what it is)

Then look in the trace just below it to see what values were actually being passed in - in particular does the 'E236' appear.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Joe Giessner wrote in message ...
>Actually, I hadn't thought about how ConText would handle multiple words
>in a soundex query. This is something I'll have to consider
>later. Thanks.
>
>However, I still have my problem. Most of the searching I'm doing (at
>least now) is single word searches. Here's the perfect example of
>what I'm working with:
>
>Looking at the view that was generated on indexing, there are 23 words
>that have the same soundex as 'excedrin' (E236). When I do a ConText
>soundex query on 'excedrin' (e.g., "contains(item_desc, '!excedrin', 0) >
>0"), I get 121 rows returned. However, when I do a ConText soundex query
>on a word that has the same soundex (like the common misspelling
>'excedren'), but is not in the column, 0 rows are returned.
Received on Mon May 03 1999 - 10:58:28 CDT