How to increase the performance of oracle73 under NT4 server?

Hi, I have a dual pentium pro 180 with 64megs ran, running NT4 server with sp2, IIS3.

Currently I have a 20meg table in oracle. And on average, it takes 7-15 seconds for a SQL query like the following to complete.

select * from IEEE_ADMIN.SAMIEEE where (FIRST_NAME='aaa' AND LAST_NAME='bbb);

I watched the CPU meter, throughout the query, both CPU's were constantly under 9%

Is there a way to instruct oracle server to take full advantage of the processing power? It would be pretty crazy to have the web users wait for 10-15 seconds before they get the results. Or maybe there is a more efficient SQL string?

thanks in advance! Received on Mon Mar 17 1997 - 00:00:00 CST