Re: connect slower than on informix

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.

If it is taking seven seconds ... it is you and your connection ... not Oracle.

I connect on a 64MB IBM ThinkPad to Oracle 8.1.7 in about one second. I connect on an 512MB IBM ThinkPad to Oracle 9.2 in less than one second. And that is about the same as on my Solaris and HP/UX servers.

If you are trying to log on just after startup you may be bumping into the Oracle startup. Otherwise I'd take a look at your entire SQL*Net connection and trace it if need be.

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