Re: connect slower than on informix

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 06 Nov 2002 16:51:10 GMT
Message-ID: <3DC94871.4C79CDBF@exesolutions.com>

Johann Kropf wrote:

> why is the connect to oracle slower than to informix?
> informix takes about 1 second and oracle about 7 seconds.
> tested with sqlpus for oracle and isql for informix.
>
> we have oracle 8.1.7 and informix dynamic server 7.31.
>
> the oracle database runs on an ibm p-series 660 6h1, 5 GB memory, 4
> processors of type rs64 IV 600 Mhz, with 150 users connected to that server.
>
> the informix database runs on an ibm rs6000, 1 GB memory, 4 processors
> of type powerpc 601, 50 users connected to that server.

The problem is not with Oracle. It is with your set-up.

Trace and examine all aspects of your connection.

Daniel Morgan Received on Wed Nov 06 2002 - 10:51:10 CST