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

Hi <unknown> ;-)

i'd try a

create index samieee_x_name_ln on samieee (first_name, last_name) storage (initial 10M next 1M pctincrease 0);

To be shure your statistics data for the cost-based optimizer is created use: alter table samieee estimate statistice.

It's not unusual (for me on UNIX) that the CPU utilisation is low if there is a heavy search because the I/o is busy not the CPU.

With proper indexing you should get you answers < 1 sec.

Kind regards,

Toni

In article <332cc1d6.1111250_at_news.total.net>, lao2_at_total.net (WPL) wrote:

> 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!
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |