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

From: Bricklen <bricklen_at_shaw.ca>
Date: Tue, 05 Feb 2002 19:52:17 GMT
Message-ID: <3C6037A5.1AD8604C@shaw.ca>

look up tuning and bind variables at asktom.oracle.com for some good hints on what to try.

sql tuning is going to be the key here, I think.

Matthew Inger wrote:
>
> 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 - 13:52:17 CST