Re: Intermedia Text Contains with "%" Hogs CPU
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 19 Sep 2000 10:24:12 +0100
Message-ID: <8q7bbt$d7i$1_at_soap.pipex.net>
Date: Tue, 19 Sep 2000 10:24:12 +0100
Message-ID: <8q7bbt$d7i$1_at_soap.pipex.net>
We had a very similar problem on NT and I believe we found that it was a documented bug with 8.1.5.0. I can't actually lay my hands on the TAR we raised with Oracle at the Mo so I can't tell you for sure. I believe that there is a workaround doubling up the % so contains (myword%%....).
-- Niall Litchfield Oracle DBA Audit Commission UK"Lex" <mlecza_at_amsnet.com> wrote in message news:8q5lbe$vvk$1_at_nnrp1.deja.com...Received on Tue Sep 19 2000 - 11:24:12 CEST
> When doing a queriy that has the % after the keyword the CPU on the DB
> server goes to 100%. The same query w/o the % are lightning quick. The
> db is on a Solaris box with 2GB RAM and 2 450 processor.
>
> What could cause this behavior?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.