Re: Oracle 8.1.6 (.3.7) Using 100% CPU

From: Titi <thierry.constant2_at_wanadoo.fr>
Date: Tue, 5 Feb 2002 21:56:33 +0100
Message-ID: <3c60462c$0$23523$626a54ce@news.free.fr>

Hi,

I have the same problem, is it a known bug ????

"Matthew Inger" <matti_at_sedonacorp.com> a écrit dans le message de news: 53480dd8.0202051128.7c1c6f49_at_posting.google.com...
> I am running Oracle 8.1.6.3.7 on a WinNT SP6, 800Mhz machine.
>
> Some of the queries are doing joins between very large tables.
> These queries take a long time, but do eventually finish. However,
> when multiple user connect and try to execute these same type
> of queries at the same time, the Oracle process consumes 100% of
> the CPU and never relinquishes it. I have tried configuring all
> sorts of oracle parameters (sort_area_size, db_block_buffers), etc...
> but nothing seems to help. The tables being queried, for the most
> part have indexes on the columns used to join the tables, so it
> should not be doing full table scans (though sometimes i see
> this anyway, despite the indexes). Has anyone else run into
> this same sort of problem?
Received on Tue Feb 05 2002 - 14:56:33 CST