Re: How to increase the performance of oracle73 under NT4 server?

How are your database files placed on your drive(s)? Is the NT system and system swap on the same drive as Oracle? How big is the SGA (# blocks and their size)? If you are using Oracle as it comes 'out of the box' on NT, very little has been optimized as to placement of files, etc.

WPL <lao2_at_total.net> wrote in article <332cc1d6.1111250_at_news.total.net>...
> 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