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:28:27 CST
