Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.6 (.3.7) Using 100% CPU
Hi Matthew,
two things to do figure out what is going on:
- get the execution plan of the query
- trace the session with event 10046 and level 12
Regards
Stefan
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 Wed Feb 06 2002 - 01:50:43 CST