Re: connect slower than on informix

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Wed, 6 Nov 2002 11:44:57 -0000
Message-ID: <Zg7y9.27062$zX3.68005@news.indigo.ie>

Where are the clients that are connecting slowly ?

does SQLPLUS via BEQ at the server connect instantly ?

prob. a name resolution problem - what's in tnsnames and sqlnet

push on the SQL*NET tracing and you'll see your answer in packets.

"Johann Kropf" <Johann.Kropf_at_gmx.net> wrote in message news:3dc8bf0f$0$25572$91cee783_at_newsreader02.highway.telekom.at...
> 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.
>
Received on Wed Nov 06 2002 - 05:44:57 CST