Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CONTEXT index maintenance?
What queries or indexing is hanging your application. Hang or Spin?
I found that a high-frequency term in combination with the minus operator would make the the query spin and take 90-100% CPU.
For example, if the search term were 'sister-in-law' and the query was not properly formulated, the query would spin. The optimizer is slightly confused because '-' is an operator not a join character (unless you so specify in your policy preference).
Solution: parse query so that 'sister-in-law' is enclosed in curly braces
and considered a phrase
'{sister-in-law}' Also, you might want to add '-' as a print-join in your
preferences.
"Giovanni Azua" <bravegag_at_hotmail.com> wrote in message
news:b54mol$25jet9$1_at_ID-114658.news.dfncis.de...
> Hello all,
>
> I extensively use Oracle Text within a CRM application for
> deduplication, the problem is that at some point the queries
> on the CONTEXT indexes completely hang the application.
>
> I periodically synchronize the index:
> ctx_ddl.sync_index('myindex', '2M')
>
> and also have tried to fix the problem by optimizing/defragmenting them:
> begin
> ctx_ddl.optimize_index('myindex', 'FULL');
> end;
> /
>
> but the problem is still there, appear to have those CONTEXT
> indexes as the only ones without analyzing ... I also verified there is
> no REBUILD or ANALYZE index statement for CONTEXT indexes.
> My only solution seems to be roughly drop and recreate them, is that
right?
>
> Thanks in advace,
> Best Regards,
> Giovanni
>
>
>
>
Received on Wed Mar 19 2003 - 03:34:54 CST