Re: Serious trouble with performance under NT4.0

From: <xjbshaw_at_ingr.com>
Date: Wed, 02 Sep 1998 15:57:00 -0500
Message-ID: <5auy6Qr19GA.62@pet.hiwaay.net>

try checking your always_anti_join init parameter - in 7.1 it was nested loops in 7.3 the default was nothing and this slowed some things way down.

In article <6seg9k$940$1_at_platane.wanadoo.fr>, "Denis Crespe" <denis.crespe_at_wanadoo.fr> writes:

>Hi,
>
>I use Oracle 7.3.4 and NT4.0 (PC dual Pentium II 300 , 512 MB RAM).
>I have a user with a schema including near of 300 tables.
>When I write a select statment between 3 tables ( 100.000 rows, 300
>rows ans
>1000 rows ), I am 10 seconds waiting for.
>
>I guess I had not the trouble with Oracle 7.1.3.
>May be it is a internal parameter of the Oracle Server.
>
>Oracle corp says their own server doesn't work very well under NT, is
>it
>true ?
>
>Thank-you
>
>Denis Crespe
>
>
>
>
>
>
Received on Wed Sep 02 1998 - 15:57:00 CDT